Using DTS to import / append data from Oracle to SQL2000 without causing Primary key constaint errors
Posted on 2004-08-25
I'm using using DTS in SQL2000 to import data from Oracle. The DTS job is using a straightforward default append statement in ActiveX. However, I'm importing old data each time as well as updated information from Oracle and this predictably causes PK violations. To get around the problem I'm deleting all data from the destination table in SQL prior to each import. This is obviously very inefficent and not scalable.
Is there a way of skipping these errors so that the DTS import job ignores the PK constaints and continues to import new data?