• The number of tasks that can run concurrently in a ssis package is dependent of some parameters.

    - the number of processors available

    - the value of MaxConcurrentExecutables

    - the value of EngineThreads

    Make sure that your master package adheres to these parameters.

    You can find more information here:

    http://blogs.msdn.com/b/sqlperf/archive/2007/05/11/implement-parallel-execution-in-ssis.aspx

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP