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