How to use transaction in SSIS? Thanks !

for using transaction in SSIS, first of all you need to start "Distributed Transaction Coordinator" and then you can put all tasks which you want to have in one transaction in a container, like sequence container, and set the TransactionOption property of sequence container to Required. if you want to overlook the transaction in some of tasks like logging tasks you can set transaction option of that task to NotSupported. here is an example: http://www.mssqltips.com/sqlservertip/1585/how-to-use-transactions-in-sql-server-integration-services-ssis/ http://www.rad.pasfu.com

Check : http://msdn.microsoft.com/en-us/library/ms137690.aspx http://lanestechblog.blogspot.com/2010/04/utilizing-transactions-in-ssis-to.html If a post answers your question, please click "Mark As Answer" on that post or "Vote as Helpful". Blog : My Blog

Check : http://msdn.microsoft.com/en-us/library/ms137690.aspx http://lanestechblog.blogspot.com/2010/04/utilizing-transactions-in-ssis-to.html If a post answers your question, please click "Mark As Answer" on that post or "Vote as Helpful". Blog : My Blog

for using transaction in SSIS, first of all you need to start "Distributed Transaction Coordinator" and then you can put all tasks which you want to have in one transaction in a container, like sequence container, and set the TransactionOption property of sequence container to Required. if you want to overlook the transaction in some of tasks like logging tasks you can set transaction option of that task to NotSupported. here is an example: http://www.mssqltips.com/sqlservertip/1585/how-to-use-transactions-in-sql-server-integration-services-ssis/ http://www.rad.pasfu.com

Here is a SSIS Transaction example: http://microsoft-ssis.blogspot.com/2011/01/ssis-transactions.html

Here is a SSIS Transaction example: http://microsoft-ssis.blogspot.com/2011/01/ssis-transactions.html