I have 4 steps say 1,2,3,4,5 in SSIS script.The steps 4 and 5 are depedent on 2, hence it starts once the step 2 is completed. Steps 2 and 3 are independent. Normally when the execution begins the step 1 is started and once it is done, step2 and step3 are parallely executed. This is how I have given the flow. Step 3 takes more time to finish the process than step2. Once the step2 is done, Steps 4 and 5 will be starting. My problem now is even though step2 is finished, the child steps 4 and 5 are not even starting. but they are started once the step3 is finished. It seems both the child steps start to execute when the step3 is executed. but there is no flow from step 3 to step 4 & 5. What is the catch here. Step2 waits for step3 to get completed. These are independent steps and both have different sources as well. How do I fix this issue? or what would have caused this issue?
Step1
|_________
| |
Step2 Step3
|_______
| |
Step4 Step5
Karthi,
You need to revisit all the constraints to make sure Step 4 and 5 depends only on successful completion of Step 2. I have reproduced your scenario and the package is executing Steps 4 and 4 regardless of 3.