June 27, 2012 at 1:25 pm
Hi We got a Parent package which got some child packages and we set the Parent package to be transactional such a way that if any child package fails all the packages gets rolled back...
So in one child package we have a conditional split and for each record if this condition insert into table1 with one modification and if not insert into table 1 with another modification..
At one point when this package starts executing we are getting an error it failed as we are having some uncommitted transactions..
Can you please help me out on this and sorry if i was not clear
June 27, 2012 at 4:12 pm
Can you describe exactly how you have the transactions organized and in what kind of containers? Also, what are your settings for the different connections (in particular Keep same connection?).
SSIS + Transactions is a very intricate component, unfortunately. If you can, try to test each package independently to find out which particular package is causing the failure. The more you can narrow it down to a particular dataflow the better off we'll be able to help you in this.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 27, 2012 at 4:15 pm
Evil Kraig F (6/27/2012)
If you can, try to test each package independently to find out which particular package is causing the failure. The more you can narrow it down to a particular dataflow the better off we'll be able to help you in this.
That's the same approach I often take when dealing with SSIS failures.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply