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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Quick quesion on DTS ODBC Connection

Author  Topic 

imsganesh
Starting Member

28 Posts

Posted - 2005-05-11 : 14:13:32
Hi All, one quick ques!

I'm creating DTS Packages from my local machines (client) using the File DSN in the connection. Is it mandatory that this file DSN needs to be present in Server machine also, to execute the package? I guess, the connection information is also saved with the package. Am i right? Please Advice!

Thanks in Advance,
Ganesh

elwoos
Master Smack Fu Yak Hacker

2052 Posts

Posted - 2005-05-12 : 14:14:09
I would guess and that's all it is - that the server would need access to the file that contains the DSN information

steve

A sarcasm detector, what a great idea.
Go to Top of Page
   

- Advertisement -