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

Do the tables have a primary key? If they do you can write a query to
exclude the records already transformed.

Rick

"Marco Pais gmail.com>" <marco.pais@<IGNORE> wrote

Hi.

They have a primary key. How/where can I write that query?

Marco

"Rick Gittins" <rgittins (AT) dungarvin (DOT) com> escreveu na mensagem
news:%23ajiG4TjFHA.1044 (AT) tk2msftngp13 (DOT) phx.gbl...

I would suggest you first get your data from SQL Server to a temporary table
in Oracle, and then use the MINUS operator to work out which rows don't
already exist in your main Oracle table.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/


"Marco Pais" <IGNOREmarco.pais (AT) gmail (DOT) com> wrote

In message <uroCkbVjFHA.3316 (AT) TK2MSFTNGP14 (DOT) phx.gbl>, Narayana Vyas
Kondreddi <answer_me (AT) hotmail (DOT) com> writes
It might be a bit expensive if you have a lot of rows. Perhaps you could
use a date parameter to exclude old rows, and only transfer the latest
rows. If you can rely on dates or some other regularly increasing (key)
value. If it is not accurate enough transfer a bit more than you need
then use the MINUS idea as above, but it should save all data moving
across.


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org