SSIS flat file insertion failure to rollback
Posted
by Pramodtech
on Stack Overflow
See other posts from Stack Overflow
or by Pramodtech
Published on 2010-03-12T06:03:10Z
Indexed on
2010/03/12
6:07 UTC
Read the original article
Hit count: 407
ssis
I have simple SSIS package which reads data from flat file and insert into SQL database. The file has 90K rows and sometimes because of bad data package fails but it insert the partial records before it fails. What I need is if insertion fails at any time between, no records should be inserted into DB, rollback everything. how can I put it in transaction?
© Stack Overflow or respective owner
