The Begin Simple Transaction component allows you to start a transaction on a connection. The connection is then set automatically into a mode so that the same connection and transaction context are shared by all components that use the connection until a Commit Simple Transaction or a Rollback Simple Transaction.

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 initiate the transaction, for example to specify an explicit isolation level.