Here I would like to know one thing. While setting DTS package properties, I had enabled Use Transactions option in DTS package properties - Advanced Tab. So that transaction will be rolled back whenever DTS get fails.
Transaction Isolation Level is Read Committed These both options are as default behavior. However when I run DTS, one of my step (whom I have intentionally kept to fail) fails, later my DTS keeps its execution as I had On Completion workflow precedence. When I verified the destination table, I found they had records transferred successfully.
Can you please suggest me, what the exactly use of keeping the Use Transactions option enable? Why didn’t me transactions get rolled back? Question sounds bit silly, but I am bit new in DTS programming.
Thanks in advance,
asked Oct 21 '09 at 03:39 AM in Default
Here's a link to an MSDN article that should help: http://msdn.microsoft.com/en-us/library/aa933474(SQL.80).aspx
I hope this helps.
answered Oct 21 '09 at 04:20 AM