DTS package error - SQL Server Forums

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)

DTS package error

Author

Topic

fordyh
Starting Member

5 Posts

Posted - 2008-09-24 : 08:57:14

Step Error Source: Microsoft SQL-DMO (ODBC SQLState: 42000)
Step Error Description:[Microsoft][ODBC SQL Server Driver][SQL Server]Column or parameter #14: Cannot find data type TermsPercentType.
Step Error code: 80040A9B
Step Error Help FileTongue TiedQLDMO80.hlp
Step Error Help Context ID:1131

The package copies a database from one server to another and errors out after about 2.5 hours.

Anyone know where or how to start diagnosing this error. I found some code to search tables for data types hoping to find the column giving trouble, but the results never help.

Thanks and I hope this is posted in the right place.
Andy

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-09-24 : 09:27:57

Can't you just backup and restore to other server?

fordyh
Starting Member

5 Posts

Posted - 2008-09-26 : 09:23:10

Thanks but I figured out a user defined data type was holding the whole thing up.

Andy

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources