Share via


How to: Configure a Package to Use Multiple Transactions

[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]

This procedure describes how to configure a package to use multiple transactions. The package must be configured to support transactions, which are then initiated by the tasks or containers in the package.

To configure a package to use multiple transactions

  1. In Business Intelligence Development Studio, open the Integration Services project that contains the package you want to configure to use a transaction.

  2. In Solution Explorer, double-click the package to open it.

  3. Click the Control Flow tab.

  4. Right-click anywhere in the background of the control flow design surface, and then click Properties.

  5. In the Properties window, set the TransactionOption property to Supported.

    Note

    The package supports transactions, but the transactions are started by task or containers in the package.

  6. On the design surface of the Control Flow tab, right-click the task or the container in the package for which you want to start a transaction, and then click Properties.

  7. In the Properties window, set the TransactionOption property to Required.

  8. If a transaction is started by a container, right-click the task or the container that you want to enroll in the transaction, and then click Properties.

  9. In the Properties window, set the TransactionOption property to Supported.

    Note

    To enlist a connection in a transaction, enroll the tasks that use the connection in the transaction. For more information, see Integration Services Connections.

  10. Repeat steps 6 through 9 for each task and container that participates in the transactions.

See Also

Tasks

How to: Configure a Package to Use a Transaction
Incorporating Transactions in Packages

Concepts

Package How-to Topics (Integration Services)

Help and Information

Getting SQL Server 2008 Assistance