Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AlexCold
Starting Member
39 Posts |
 Posted - 2002-07-29 : 11:22:20
|
I'm really sorry guys for this question...  I need to run DTS package on remote sql server. I connect to the server through MMC. Txt file with data is on the same server. When I try to create new connection using text as source I'm not able to point path to the txt file on the same server. All I can is to select txt file on my local machine. How can I tell SQL server that source file is the same machine not on mine?-- Success is a journey, not a destination!!FAQTeam memberhttp://www.faqteam.org/ |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-07-29 : 11:36:32
|
| Use the UNC filepath....Jay White{0} |
 |
|
|
|
|
|
DTSing from the txt file on remote machine