DTS transfer of table structure and data in table

[jballum]

I attempted to use DTS to transfer a table and all it's data from one Server to another. The structure was copied correctly but during the data transfer it failed. The cause of failure was due to a unique constraint violation.

I dropped the indexes on the destination table and used DTS to attempt to load the data again and it came across successfully (as it should). Then I attempted to create the index with the unique constraint and it worked (as it shouldn't if the data had a constraint violation as DTS indicated in the first instance).

Anyway, I was wondering if anyone has run into this problem before when attempting to use DTS to transfer a table object (everything included) as well as it's data.

Thanx

JB

 

[jballum]

Did some further checking and found that one server had Service Pack 2 installed while the other one was still with Service Pack 1.

Still got an odd error when attempting to load all data into all tables. I received a foreign key violation on one table. I attempted to load the data again from this table and it worked fine.

Is DTS a truly trustworthy tool?????

Thanx

JB