DTS Transactions – calling other packages | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DTS Transactions – calling other packages

I have a DTS package (we’ll call it Bob) which will be calling a number of other DTS packages. The whole process needs to be within a transcation and any failure needs to rollback the transaction. Now I think I’ve got it working but I wanted to just check if anything else can confirm my setup. Now Bob starts the transaction and all steps have "Join transaction if present" and "Rollback transaction on failure" checked. Bob has the option "Commit on successful package completion" checked. All of the DTS packages that are called have "Use transacations" checked but do not have "Commit on successful package completion" checked. They also have "Fail package on first error" checked. Every step within the DTS packages that are called have "Join transaction if present" and "Rollback transcation on failure" checked.
Refer http://www.databasejournal.com/features/mssql/article.php/1462561] _________
Satya SKJ
I’ve looked at that article and it doesn’t mention transactions [<img src=’/community/emoticons/emotion-6.gif’ alt=’:(‘ />]
Sounds correct to me, it is how I do it. Only the outer most DTS package should have "Commit on successful package completion" checked if you want one big transaction. /Argyle
]]>