Please start any new threads on our new site at 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)
 DTS Error -2147221296

Author  Topic 

Amanda O
Starting Member

1 Post

Posted - 2010-01-21 : 11:44:15
I have a DTS package that is copying a db between two machines. It is failing and throwing this error: error code -2147221296. Can anyone tell me where I can find a definition for this code? Or what it means?


5072 Posts

Posted - 2010-01-21 : 12:07:25
in the dts package, have it log results to a file. this will give you verbose error messaging to help identify the problem.

right-click blank space on dts designer. click package properties. go to logging tab. type in the path to error file.

then run the package and post any error messages in the file.

by the way, are you running SP4?
Go to Top of Page

- Advertisement -