July 5, 2012 at 3:27 pm
Please see attachment.
I have the same stored proc running in different servers at the same time ( inside the for loop )
What happens if one of the processes inside the loop gets completed before the others,
My question is how can we modify this pcakage to make sure that the stored proc ran completely on all servers before going to the next iteration in the for loop.
July 5, 2012 at 3:29 pm
That should already be occuring unless someone's been messing around with the allowable error counts and error inheritance in the components. A single fail should stop the process completely before the next loop ignites.
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
July 5, 2012 at 3:34 pm
So you are saying I don't have to modify this any more.
You mean, if there is one error along any path the entire package will stop ?
Cool.
Please reply
July 5, 2012 at 3:41 pm
mw112009 (7/5/2012)
So you are saying I don't have to modify this any more.You mean, if there is one error along any path the entire package will stop ?
Cool.
Please reply
Unless you've mucked with default settings yes, the loop will stop. Each independent path MAY complete, as they're not reliant on each other and will depend on timing, but the loop will not continue as it's dependent on success for all internal pieces... UNLESS you've changed things like MaximumErrorCount from 1 or other pieces.
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply