In the Properties window, select Propagate Rollback to enable transactionality support for the generated jobs or projects. When you select this option, data is committed at the end of the write operation for a successful execution, and rolled back for an unsuccessful execution. If you do not select the option, the project does not enforce a transaction rollback on successful components, if one or more components fail. Failed components rollback their own transactions. Jobs also, when Propagate Rollback is not selected, do not enforce transaction rollbacks on successful projects, if one or more projects fail. The failed projects roll back their own transactions.
If Propagate Rollback is selected for a project or job,
and there are multiple components that are a target for the same
table, also select the Shared connection property for all these
components. Otherwise, ETL may stop responding.
