"Raka" <rational_ed@yahoo.com> wrote in message
news:89de01c34565$f6e45b40$a401280a@phx.gbl...
> \\testserv\Bi$\SAP\inventory_onhand.txt
> where testserv is the server name and bi is share name.
> Did i write it correctly?
>
>
>
> >-----Original Message-----
> >To access another machine from that on which DTS is
> executing you can use a
> >UNC path (\\Machine\Share\File.txt).
> >
> >Or
> >
> >Run the package on the same machine as where you want the
> file.
> >
> >
> >--
> >Darren Green
> >http://www.sqldts.com
> >
> >"Raka" <rational_ed@yahoo.com> wrote in message
> >news:027701c344c3$698c74f0$a501280a@phx.gbl...
> >> Hi ,
> >> I have created a DTS package in SQL server 2000 which
> will
> >> write the contents of the table data to a text file.
> >> When the Job is invoked it creates the .txt file and
> saves
> >> it on the above server.It works fine for now
> >>
> >> If i decide to save the .txt file on some other server
> how
> >> should i do that ?
> >> Thanks for help
> >>
> >>
> >> Raka.
> >
> >
> >.
> >