July 3, 2014 at 6:33 am
Hi Folks,
I have a master package calling a child package 5 times in parallel. At times, we are observing that local variables in child package are assigned with values from other execution of same package.
We are using SQL 2012.
Anybody has any thoughts on what might be happening?
Thanks
July 3, 2014 at 8:09 am
I think we need more details to be able to provide any kind of help.
If I understand correctly you have a package variable (in the parent package?) the is being used by the child packages (same package called 5 times in parallel) and sometimes the variable will not have the correct value for the child package because it has the value from one of the other child packages?
I'd suggest running the packages either in linear mode or reducing the parallel execution to 2 at a time.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 3, 2014 at 11:26 pm
The variable is not in master package. The variables of child package are getting values from other running instance of the child package. I see this mentioned in some of the blogs but there is no resolution.
Look at comment #5 in this: http://social.msdn.microsoft.com/Forums/sqlserver/en-US/a1ee42de-188f-4333-84ca-109a6c5a3079/executing-multiple-instances-of-ssis-package-in-parallel
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply