setting path for "text file (source)"

#1

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

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

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

How would I change the file name to allow the remote dts package t
access files on the remote machine

-Dav

#2

Would a UNC path work for you?

\\ServerName\ShareName\FileName

Allan

"wireless" wrote:

Quote:

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 path is
c:\filepath\file.txt.

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

-Dave

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

setting path for "text file (source)"

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

setting path for "text file (source)" - 05-25-2005 , 01:02 AM

RE: setting path for "text file (source)" - 05-25-2005 , 02:24 AM