Post reply

how to run the tasks in parallel manner

  • June 22, 2011 at 1:51 am

    #242931

    Hi All,

    I have placed 5 EXEC SQL TASKS in control flow in parallel manner.

    When i am executing the package, only 3 SQL tasks are running in parallel manner. The remaining two jobs are started to run after the already running 3 SQL tasks completion.

    My requirement: Need to run all the 5 EXEC SQL TASKS in parallel manner.

    Do i need to set any property to achieve this.

    Thanks in Advance.

  • June 22, 2011 at 9:23 am

    #1342488

    By default it will run up to 10(I think) processes in parallel. What you are experiencing is very likely SSIS "throttling", it can't run all 5 well at the same time so it only runs three, I've seen this many times, there IS a way around it BUT it is tricky and I don't recommend it.

    I wrote a pair of articles on this topic, see the last example in part 2:

    http://www.sqlservercentral.com/Authors/Articles/Elliott__Whitlow_/483442/[/url]

    Also, I would ask why you are so adament that it runs all 5 at the same time?

    CEWII

  • June 22, 2011 at 8:57 pm

    #1342776

    How many physical CPUs do you have?

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply