question

Bhupendra99 avatar image
Bhupendra99 asked

Control Flow are Synchronus and allows Parallel execution

while reading about Control flow I came accross two diffrent statetment which are very confusing in nature , they are mentioned below 1) Control flow Task are Synchronous in nature, this means, task requires completion before moving to next task. 2) If the tasks are not connected with each other but still they are synchronous in nature. 3) Tasks can be executed both parallel and serially So if a Control Flow task is Synchronous in nature irrespective of they are connected or not how can they executed parallel means first task have to finish first for the second to start
ssis
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
JohnM avatar image
JohnM answered
I believe, if I understand correctly, it's telling you that you can execute tasks within the control flow in parallel or serially. Each task within the control flow requires completion before moving to the next task connected to it. The control flow is very much process oriented and I tend to think of like a flow diagram for application development. Take this example: 1. The data flow task must complete before the subsequent loop containers start. 2. Once the data flow task completes, all three of the foreach loop containers would fire in parallel 3. The second data flow task won't fire until all three foreach loop containers are done. ![alt text][1] [1]: /storage/temp/3282-ssis-parallel.png Hope that helps!

ssis-parallel.png (26.0 KiB)
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.