Rollback SSIS Data Flow Tasks if one fails

Question

In my SSIS package I have several data flow tasks.

Is there a way in SSIS which says if the F0101Z2 task completes but the F03012Z1 fails rollback what was passed in the F0101Z2 step?

Any guidance would be appreciated.

Thanks

Answer 1

Set TransactionOption=Required on Package Level, and configure all Tasks to TransactionOption=Supported(by default Supported). They will all join the transaction, and if any fail, the transaction will be rolled back. Note: First Make Sure that MSDTC(MS Distributed Transaction Co-coordinator) is enabled in the Control Panel--->Admin tool-->Services.