O'Reilly logo

Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition by Guy Fouché, Lynn Langit

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using Transactions in SSIS Packages

SSIS packages support the grouping of tasks into transactions by using one of two methods. You can either use the Distributed Transaction Coordinator (DTC), or you can use the transactions that are built in to your relational database management system (RDMS), such as SQL Server or Oracle. The primary factor to consider is the span of the tasks.

If your business needs call for transactions that must go across multiple data sources or connections, you must use DTC transactions. To use DTC transactions, you must ensure that the DTC service is installed and running. You then configure the transaction option at a package or task level by setting the TransactionOption property to either Required or Supported. You'll ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required