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
 SQL Server Administration (2000)
 Connection Failures with large DTS package

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-08-06 : 00:33:22
Wendy writes "We have DTS packages with almost 300 tables each. They are being used to copy data from a 6.5 server (Win NT machine) to 2000 (on a Win 2K machine). Out of the three packages, one runs just fine, however, the other two continually error out with a "Connection Failure".

Is DTS really the best way to accomplish the data transfer?

What could be causing the Connection Failure? We have tried to locate any network problems, but have been unable to find any. Are there possibly some system settings we need to be looking for?

Thank you for your help."
   

- Advertisement -