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
Supported. You'll ...