<hector.caban@gmail.com> wrote in message
news:1114786194.413804.94410@g14g2000cwa.googlegroups.com...
> 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
>