Hi!
I have a DTS that has a transform task SQL -> Oracle,
this task is based in a source query.
When inserting many rows in Oracle and if there's a
problem (like PK violation), the task insert all the rows
until the problematic row. It doens't do a rollback, that
is an expected behaviour for me.
If the same thing happen in SQL, this is true, the
transform task is an entire transaction.
I'd like to now if this behaviour in Oracle is linked
with the OLEDB Provider or the Server Oracle?
I tried to do this with the Oracle OLEDB Provider and MS
OLEDB Provider to Oracle.
Thanks for any help.

Alexandre Calderaro
Avanade Italy