Sequence Container will help your problem. Sequence container commits the transaction if it completes successfully, an it rolls backs the transaction if it fails any one of the execution

In Sequence Container simply configuring the TransactionOption property to have the value REQUIRED.

🙂