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)
 Skipping or Logging

Author  Topic 

gaiams
Starting Member

1 Post

Posted - 2005-10-12 : 12:35:29
Hello,
Is there a way to skip a record that violates primary key constraints in a DTS package which just copies data from one table to another.
Any help would be greatly appreciated.
Thanks
Greg

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2005-10-13 : 06:08:52
Write the query to check for duplicates beforehand/while processing
Go to Top of Page
   

- Advertisement -