Transaction

Question

Hi what is transaction ...how to use transactions in ssis level.and how to roll back components..

---

N.suresh

Answer 1

Google
SSIS transactions: http://microsoft-ssis.blogspot.com/2011/01/ssis-transactions.html
TSQL transactions in SSIS: http://microsoft-ssis.blogspot.com/2011/09/ssis-transactions-with-tsql.html

---

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

Answer 2

Hi suresh,

Packages use transactions to bind the database actions that tasks perform into atomic units, and by doing this maintain data integrity. All Microsoft Integration Services container types—packages, the For Loop, Foreach Loop, and Sequence containers, and the task hosts that encapsulate each task—can be configured to use transactions. Integration Services provides three options for configuring transactions: NotSupported, Supported, and Required. Please see: http://msdn.microsoft.com/en-us/library/ms137690.aspx

For more information about how to use Transactions in SQL Server Integration Services, please see: http://www.mssqltips.com/sqlservertip/1585/how-to-use-transactions-in-sql-server-integration-services-ssis/

Thanks,
Eileen

---

Eileen Zhao

TechNet Community Support