January 7, 2008 at 8:26 am
We have an SSIS project that executes several SQL Tasks (stored procedures) in parallel. We are now putting the try/Catch processes with rollback of the transaction (SP) if the process identifies an error so the initial receiving tables remain unchanged if there is an error identified. Can someone tell me if there is a possibility of the journal mixing up the transactions to be rolled back if the parallel processes each have an open transaction?
If this is possible, would naming the transaction on the "Begin Transaction" and associated transaction activity avoid this?
Thank you,
Howard Bachtel
January 7, 2008 at 8:35 am
The transaction rolled back by a proc is only the transaction from that proc, and any procs called by that proc that haven't already committed. Multiple procs run in parallel won't cross transactions unless you are allowing non-isolated transactions (which are disallowed by default).
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply