I'm trying to implement transactions by setting RetainSameConnection to true. Please see my package setup below. It is running fine when data flow task is running successfully, but when DFT fails rollback transaction execute sql task is failing with an error: can't find an associated begin transaction. I'm expecting the rollback to succeed because it's configured to use the same connection. Am i doing something wrong here? Created source and destination OLEDB connections to SQL Server R2 databases.RetainSameConnection is set to true for the destination connection.First task is an execute sql task with destination connection to begin a transaction.Second is a data flow task loading data from source to destination. Destination table access is table or view fast load.Next is an execute sql task to commit the transaction on success of data flow task, and another execute sql task to rollback transaction on error of data flow. Thank you, Samuel.Regards, Samuel Vanga Twitter Blog

Did you name the transaction? Here is an example of TSQL transactions within 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