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

Comments (1)

  1. ETL vs ELTL says:

    The link which you provided are now not available and getting following error

    "Error 404 – Page not found!

    The page you trying to reach does not exist, or has been moved. Please use the menus or the search box to find what you are looking for."

    Please update your post so that we can read your article.

Skip to main content