MaxConcurrentExecutables Parameter : Parallel Procesing of Packages
Hi, i got number of extraction feeds (from source to staging), performing simple data extraction into staging database. I would like to run these packages parallel in master package( at least 3 packages at a time). to execute these child packages, need to use number of execute Package tasks in sequence container of master package. Instead of using number of execute package tasks, can i use for each loop containers( at least 3, to run 3 child packages at a time) in sequence container. Maxconcurrentexecutables Parameter runs different tasks parallel, but not containers.Could you please suggest me the best possible way to implement parallel execution of SSIS packages Jai
May 12th, 2011 5:01pm

Thanks Kalman for Replying.... I would like to put 3 for each loop containers with 3 execute package tasks, run 3 data extracts in parallel. if above is not possible, is it possible to run these child packages in parallel in scheduling side, instead of keeping this child packages in master package.
Free Windows Admin Tool Kit Click here and download it now
May 16th, 2011 4:04am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics