Microsoft SQL Server forum - setting remote path for "text file (source)"

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

setting remote path for "text file (source)" - DTS

wireless200@yahoo.com

2005-05-24, 8:24 pm

I'm running EM on my local box and sql server on a remote internet
accessed box.

How do I specify a file path for a DTS package to access files on the
remote box?

For example, to run a local dts package the filepath is
c:\filepath\file.txt.

How would I change the file path/name to allow the dts package to
access files on the same remote machine?

-Dave

Simon Hayes

2005-05-25, 3:23 am

The best idea is to use a UNC name:

\\server\share\folde
r\file.txt

That should work from anywhere, assuming that the account executing the
package has permission to access the share.

http://www.sqldts.com/default.aspx?200
http://support.microsoft.com/defaul...kb;en-us;269074

Simon

Sponsored Links