SQL Server Integration Services (SSIS) - Transaction Support

Transaction Support

By Default every component in a SSIS package executes in its own transaction. Using Transaction Support feature of SSIS you can group two or more components in a single group and let all those components inside that group to execute in single transaction.

I have written an article covering all aspects of SSIS Transaction Support functionality, starting with how to enable a transaction on a group of components, what are different options available, execution behavior in these available options, examples of Transaction support, its configuration and finally best practices to follow while using this feature.

Refer this link for more details.

http://www.sql-server-performance.com/articles/biz/SSIS_Features_And_Properties_Part2_p2.aspx