SSIS flat file insertion failure to rollback
- by Pramodtech
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?