SSIS - sequence container, but no parallelism?

  • Hi all,

    I have a sequence container with three tasks. One will succeed, two will fail. I thought the idea was so that anything in the container will run simultaneously. So, I set on pre-execution breakpoints to try to troubleshoot. Since this inherently makes them run one at a time, I they suprisingly all succeed - but again, only because the breakpoints are forcing the one-at-a-time flow. This says to me that there is a problem with parallelism.

    Does anyone have ideas on what could be preventing all three from running at ath esame time?

    Thanks,

    Sharon

  • Are the 3 tasks running against the same data (tables, views, etc.)? You may be seeing a contention problem.

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

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