Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Execute Child packages parallel in loop


Execute Child packages parallel in loop

Author
Message
jjr.123
jjr.123
Grasshopper
Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)

Group: General Forum Members
Points: 10 Visits: 116
hi ,
I have a master package which calls the child packages from a folder dynamically, when i tried this with execute package task inside a for each loop container , it is only looping the child package which is connected in the execute package task connection.
Could any please suggest me a way to achieve this task. I want the parent package to read the 1st child package , start and read next package, start and ....read last package, start.

Thanks in advance
Koen Verbeeck
Koen Verbeeck
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16447 Visits: 13202
Did you put an expression on the Execute Package Task?



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
sneumersky
sneumersky
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2162 Visits: 487
If I am not mistaken, using one execute package task (EPT) within a loop would execute the packages serially, right? Parallel EPT execution would require multiple EPTs that were not connected to each other.
Orlando Colamatteo
Orlando Colamatteo
SSCrazy Eights
SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)

Group: General Forum Members
Points: 8241 Visits: 14368
jjr.123 (7/11/2013)
hi ,
I have a master package which calls the child packages from a folder dynamically, when i tried this with execute package task inside a for each loop container , it is only looping the child package which is connected in the execute package task connection.
Could any please suggest me a way to achieve this task. I want the parent package to read the 1st child package , start and read next package, start and ....read last package, start.

Thanks in advance

Kind of a kludge, but can be done by:

1. Have Int32 var increment by 1 each time through FeLC.
2. Have extra String var to store "last pkg name" so you have access to last pkg and current pkg
3. Have dummy Script Task in place to allow for Precedence Constraint, with two connections to Execute Package Tasks and a constraint that only proceeds when the Int32 variable is divisible by 2.
One of the Execute Package Tasks will run the var "last pkg name" and the other will run the loop's current pkg.

You'll need some logic to process the last pkg in case there were an odd number picked up by the loop, but that's the gist of it. Also know that both pkgs need to complete before the loop continues. Using two loops aide by side that iterate over the same folder and process a mutually exclusive set of pkgs is also an approach that could work.

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
jjr.123
jjr.123
Grasshopper
Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)

Group: General Forum Members
Points: 10 Visits: 116
Hi Can you please share me a sample package that shows how to configure int32 variable to increment by 1 ,
other string variable to hold the packageName , and loop through packages in folder as u told above.

Thanks in advance
Koen Verbeeck
Koen Verbeeck
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16447 Visits: 13202
sneumersky (7/12/2013)
If I am not mistaken, using one execute package task (EPT) within a loop would execute the packages serially, right? Parallel EPT execution would require multiple EPTs that were not connected to each other.


You're right, that would be needed. 4 EPT tasks would be a good start I think.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Koen Verbeeck
Koen Verbeeck
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16447 Visits: 13202
jjr.123 (7/14/2013)
Hi Can you please share me a sample package that shows how to configure int32 variable to increment by 1 ,
other string variable to hold the packageName , and loop through packages in folder as u told above.

Thanks in advance


How about you start designing the package and ask a question when you run into problems, instead of relying on other people to do your job?



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Orlando Colamatteo
Orlando Colamatteo
SSCrazy Eights
SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)

Group: General Forum Members
Points: 8241 Visits: 14368
jjr.123 (7/14/2013)
Hi Can you please share me a sample package that shows how to configure int32 variable to increment by 1 ,
other string variable to hold the packageName , and loop through packages in folder as u told above.

Thanks in advance

You've been given several viable options in the form of free guidance on a public forum from volunteers who also happen to do this for a living. If you would like help producing the actual deliverable send me a Private Message or email and I am sure we can work out a fair hourly rate. If you get more into producing a solution on your own and have questions, feel free to post back to this thread or start a new one.

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
MMartin1
MMartin1
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1098 Visits: 2014
Visit Books Online and go down the SSIS tree. There are descriptions for every control flow item in there. Once you have a feel for that item start tinkering with it. This will provide you a better learning experience that quick answers answers that you will later forget, because you don't have the knowledge foundation to integrate the answers into what you already know.

----------------------------------------------------
How to post forum questions to get the best help
lijnenjoost
lijnenjoost
Grasshopper
Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)

Group: General Forum Members
Points: 23 Visits: 216
jjr.123 (7/11/2013)
hi ,
I have a master package which calls the child packages from a folder dynamically, when i tried this with execute package task inside a for each loop container , it is only looping the child package which is connected in the execute package task connection.
Could any please suggest me a way to achieve this task. I want the parent package to read the 1st child package , start and read next package, start and ....read last package, start.

Thanks in advance

Here is a parallel loop example with a queue:
http://microsoft-ssis.blogspot.com/2013/11/execute-mutliple-child-packages-in.html

Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search