Hello everyone,
I am importing a flat file using dts. I notice that if there is an
error in the file, the transactions are rolled back. I need to import
each row as a transaction in itself. How do I do that ?
For example if the There are 2000 rows and 1 row is bad then 1999 rows
should be imported. I am using a Transform Data Task. Can this be done
and how ?

Thanks,
HEctor

Set the insert commit size to 1. This is on the properties of the DataPump
task, last tab.

Darren Green
http://www.sqldts.com
http://www.sqlis.com

<hector.caban (AT) gmail (DOT) com> wrote