SQLTeam.com | Weblogs | Forums

Performing ROLLBACK TRANSACTION IN SSIS?


#1

Kindly HELP me how I can perform rollback in ssis?
I have Created a package in DFT---->OledbSource---->SqlCommand (I wrote some query) and then I mapped those data by creating destination table using Lookup I have inserted not matching records to Destination using OLEDB DEST and UPDATED DATA using OLEDBCOMMAND

Now I want set rollback if any of the task failures then it should be rollback In SSIS

I kept the DFT into SEQUENCE CONTAINER and I have configured Properties of sequence container transaction=Required,

and DFT Properties of Taransaction=Supported, and in control flow --->RightClick--->Properties-->Transaction=Required and failure package on failure =True

IS THIS CORRECT WAY TO TRANSACTION ROLLBACK AT THE SSIS IN PACKAGE