The Rollback Simple Transaction component commits the changes made to a connection following the execution of a Begin Simple Transaction component.

Typically this component would be used in an error event handler, or in other failure / cleanup scenarios.

These simple transactions have the limitation of working on only a single connection, though you can nest them as required, but they are more efficient and frequently easier to work with than the normal DTC transactions supported by SQL Server Integration Services.

To configure this component, drag an instance onto the control-flow surface, connect and predecessor task and double-click to configure.



You simply need to select the connection and optionally customize the SQL used to rollback the transaction.