MS SQL Server DTS - DTS Problem

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

DTS Problem

Microsoft

2005-07-20, 11:23 am

Hi there,

I have created a DTS that copies data from a table in SQL Server to a table
with the same structure, but in Oracle.

Lets suppose I have 100 rows in the origin table. If the DTS fails in he
middle of the operation, supposing the row 55 has an error, the previous
rows are copied to the Oracle table.

How can I now wich rows have been copied?

The DTS runs periodicaly, and I need to know wich rows are copied, so I can
block them on the SQL Server, so they can not be copied again to Oracle.

Can anybody help me? Thanks in advance.

Regards,

marco

Sponsored Links