Export (0) Print
Expand All

How to: Configure a Package to Use a Transaction

This procedure describes how to specify that a package use transactions for some or all of its tasks and containers.

  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 Required.

  6. On the design surface of the Control Flow tab, right-click the task or the container that you want to enroll in the transaction, and then click Properties.

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

    ms141144.note(en-US,SQL.90).gifNote:
    To enlist a connection in a transaction, enroll the tasks that use the connection in the transaction. For more information, see Integration Services Connections.

  8. Repeat steps 6 and 7 for each task and container.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft