July 12, 2010 at 9:29 am
Hello,
I need to develop a control package that runs all 8 child packages, it should run all child packages irrespective of their failure or success. it means, even if the first child package fails it should run all other child packages.
I started with Execute SQl task's resultset containing package location and package names from MSDB database.
With For each loop container, enumerating ADO.object source variable, so that i can read all package names from resultset to run through execute package task.
if i set execute out of process property of Execute Package task to true, will it run all child packages ??? . if not please let me know that any other options available.
Right now i am running all my packages in 64 bit, want to run few packages in 32 bit mode, using Execute process task with dtexec.exe command line utility. Even this process should run all child packages irrespective package run status. I have no idea how to archive in execute process task.... Please help me in this issue.
Thanks in Advance
Cheers
Vijay
July 12, 2010 at 2:30 pm
In your control/parent package, why don't you just use an Execute Package Task for each child package you want to run?
July 12, 2010 at 2:53 pm
right now got 8 packages... in future it might increase up to 15.....
July 13, 2010 at 4:59 am
OK, then why don't you store the child package names in a table, read the table and loop over a Execute Package Task with a for each loop (using expressions to set the properties)?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply