June 18, 2012 at 6:58 am
Hello,
I have added conditional branching to a package. I have a task (A) that sends execution to an additional task (B) if a condition is made, if not, it sends execution to a third one (C). In addition, the task that is the additional one (B) is supposed to send execution to the third one (C) when complete.
However, I can't get the additional task (B) to move things along to the third (C). For some reason I can't understand, the package stops after B is finished.
I've checked that the task result in B is set to "success". (In other words, Dts.TaskResult = ScriptResults.Success.) Also, I have deleted and recreated the green line from task B to task C repeatedly, and also checked that the constraint is set to "success". I've made sure that line from B reaches and comes into contact with C.
I've tried debugging. I put a stop with the last line of B and tried to see where it goes after it. However, nothing happens; after I hit the breakpoint, Task B closes and I am looking at the package in its entirety.
Task C is enabled; it is white in color.
Does anyone have an idea what I can do to troubleshoot the failure of Task B to send execution to Task C?
thanks,
June 18, 2012 at 8:21 am
This is strange...I deleted the precedence constraint that leaves task A and goes directly to task C. Then I ran the package under the condition that it should go from A, to B and to C. It did all three.
Then I added a dummy script task between A and C. The purpose of it is to allow execution to go from A to the dummy script; and then the dummy to C without needing any precedence constraint. Unfortunately, the package goes from A to B and does not bounce from B to C.
This is so bizarre...
June 19, 2012 at 7:03 am
I have added an "if" statement to prevent execution of Task B unless the desired condition is met. This enables me not to use branching.
Still, it is frustrating that the branching doesn't seem to work. Again, I have a Task A. If a condition is met, I want to do Task B, and then Task C. If on Task A the condition is not met, I want to move directly to Task C.
Anyhow, thanks for reading. I hope that future versions of SSIS are more easy to work with than BIDS 2008.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply