Im having a problem understanding how control flow works in an SSIS package.
I created a simple model using just Script tasks as my practice packagejust to make it as simple as possible.
Heres my observation:
Lets say I have a 3 tasks. First I have one called Task1. Below this I create two other tasks called Success and one called Failure. Using the designer, the green On Success line goes from Task1 to the Success task. The red On Failure line connects Task1 to Failure. I then edit the Task1 script so the last line reads:
Dts.TaskResult = Dts.Results.Success
When I run the package, As expected, the flow leads from Task1 to Success. If I edit the Task1 script so the last line reads:
Dts.TaskResult = Dts.Results.Failure
The flow leads from Task1 to the Failure task.
Again, this is all running as expected.
Now, I create an additional task called Task2. Its independent of Task1 and has no precedent. I have the script for Task2 return a Success result. Strangely, when I connect the red On Failure line from Task2 to the SAME Failure task that Task1 points to and run it, when Task1 fails it does NOT flow to the Failure task as it should.
Now, If I have Task2s OnFailure flow to its own failure task, everything works fine.
Can two or more tasks not flow into the same task?