Rollback in SSIS Package Level...

Posted by Kapildalke under Sql Server on 5/26/2012 | Points: 10 | Views : 3202 | Status : [Member] | Replies : 1
If you are using SSIS package for transaferring data from one database to other database.In case of any failure or any exception on any data flow task or component level .We have to rollback our old transactional in other tables where data is already inserted.

You can set the transaction option to 'required' at package level...and 'supported' for the the components(Data) that you want to rollback in case of failure.
alternatively, put the required components in a (sequence) container and set the property to required at container level..and supported for the components within.




Responses

Posted by: Sriramnandha on: 6/21/2012 [Member] Starter | Points: 25

Up
0
Down
yes u can RollBack The Transaction . In Your SQL Statements u can add
Begin Transaction

sql statements...

End Transaciton
commit
Rollback

Regards
Sriram.R

sriram

Kapildalke, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response