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)
 no sql server connection on DTS

Author  Topic 

sanjnep
Posting Yak Master

191 Posts

Posted - 2006-06-08 : 09:11:06
I am trying to create new sql server connection using DTS package but in connection section of DTS I can't see connection for SQL Server but still I can see for other connection like oracle,text,db2. Can any one help me?
Thanks
Sanjeev

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-06-08 : 14:19:57
If SQL Server isn't available in the list, then reinstall MDAC on the client where you are designing the DTS package.

Tara Kizer
aka tduggan
Go to Top of Page
   

- Advertisement -