You can probably write an ActiveX script task that uses a lookup query task
to check for the existence of the record and if so, fail the insert and
continue with the next record.
Please reply to the whole group only!
"Simon" <simon.zupanstud-moderna.si> wrote in message
news:3f054f2enews.s5.net...found> I create DTS task to copy data from one table from one database to another
> table in other database every day.
> But for the data, which was copied in the past days, it create error:
> Violation of primary key. Cannot insert duplicate key in object 'table2'.
> Is it possible to update old data and copy only the new one. I didn't> this option anywhere.
> Does anybody know how to do that?
> Thank you,