jump to navigation

SQL Server Integration Services (SSIS) – Transaction Support January 27, 2009

Posted by Arshad Ali in SQL Server Integration Services, SSIS, SSIS 2008.
trackback
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

Advertisements

Comments»

No comments yet — be the first.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: