Transactions of SQL server 2008 - SQL Server 2008

SSIS packages support transactions, which combine a group of tasks into a logical unit of work that is either wholly committed or rolled back. If two tasks are enlisted within a transaction, and the second task fails, the first task will roll back database changes previously made to a consistent state before the package executed.

To enable transactions for your SSIS package, follow these steps:

  1. In the SSIS Designer, right-click an empty area on the Control Flow design surface and select Properties.
  2. In the Properties window, change the TransactionOption property to Required. The Required option means that the SSIS will start a transaction. The Supported option does not actually start a transaction; rather, it joins any transaction already started by the package or its parent container.
  3. To enlist a specific task or container within the package transaction, click the task on the Control Flow design surface. In the Properties window, change the task’s TransactionOption property to Required.

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd Protection Status

SQL Server 2008 Topics