Clever Geek Handbook

SSIS 2008 Tasks Running Concurrently

I am not an expert, but I have some experience with BIDS / SSIS 2012. I recently had to get started in 2008 for reasons beyond my control and am having a problem that I never saw in 2012. don't seem to work. I have a series of Script and Execute SQL tasks, and after they successfully complete, the sequence container needs to start some data flow tasks. However, when I run the package, the first task (Execute SQL) and the Sequence container start at the same time. The previous steps must be completed to complete the data flow tasks. Does anyone know what I am doing wrong or how to fix it?

UPDATE 1

Please see below package picture:

enter image description here

"Prepare Tables" and "Get Adj Memo Sheet" start at the same time.

+3


source to share


1 answer


Hope I am not misunderstanding your question. It looks like you have linked the tasks incorrectly. Here is some information on completing tasks.

There are two ways to start a task.

  • at the beginning of the package execution (if this task is not related to the previous task)
  • after completing the previous task (when connecting tasks)

If multiple tasks are not related to previous tasks. They will start executing in parallel when the package starts executing.

Also, if they are grouped inside a sequence container, they will start executing when in parallel when the sequence starts.



Screenshots for parallel execution

enter image description here

enter image description here

Screenshots to complete the sequence.

enter image description here

+1


source






More articles:


All Articles