Geek Answers Handbook

Rollback SSIS data flow Tasks if one fails

In my SSIS package, I have several data flow tasks.

Is there a way in SSIS that says if task F0101Z2 is completed, but F03012Z1 does not perform rollbacks, which was passed in step F0101Z2?

My sisis package

Any guidance would be appreciated.

thanks

+4
source share
2 answers

Set TransactionOption=Required at the package level and configure all tasks to TransactionOption=Supported (supported by default) . All of them will join the transaction, and if a failure occurs, the transaction will be rejected. Note. First, make sure that MSDTC (MS-coordinated distributed transaction coordinator) is enabled in the Control Panel--->Admin tool-->Services.

+2
source

More articles:


All Articles