Grouped SSIS execution based on table

[ganjass]

Hi All,

SSIS \ SQL server 2005

I've been tasked with looking at a master control package that waits for a flag to start and then reads a workflow control table that contains a list of packages, the folder location and the groupID of the pacages, as they want certain packages to run in a loose order based on their groupid, so say 10 packages group1, 15 group2 etc.

The problem is that they also want to utilsie parallelism as well, so thats the For each loop out of the equation as thats sequential, any ideas?


Thanks

 

[MDXer]

find out the business needs for what they believe they want. To me this sounds like an inefficient process model.

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck