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 ...
Get Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
