Debugging SSIS package - why both parts are executed

Question

Hi everybody,

I am debugging an SSIS package and I don't understand why am I seeing this in debugger

I have expression constrains. One task - create header text is supposed to execute when User variable > 0, the other is executed when User Variable == 0. I press F5 and I know that my variable > 0. Why do I see both tasks executed when I debug the package?

Thanks in advance.

Answer 1

Hi @Naomi ,

You need to check your SSIS Precedence Constraint expressions coming out of the 'Get Expected Row Count' Task. Both of them. Unfortunately, the question doesn't show the SSIS Precedence Constraints.

You should try Evaluation operation: Expression and Constraint

First Precedence Constraint (Audit - nothing to extract):
(1) Value: Success
(2) Expression: @[User::RowCount] == 0

Second Precedence Constraint (Create Header Text):
(1) Value: Success
(2) Expression: @[User::RowCount] > 0

UPDATE
Please make sure that you are using the correct variable(s).
Your screen shots show that there are two different valuables are in use:

• User::varRowCount
• User::varHeaderRowCount

Answer 2

Hi Yitzhak,

No matter how I modify the constraint I still get all tasks executed (e.g. the first picture doesn't change). I tried all possible combinations for the precedence constraint. Is it what I'm seeing wrong? I would expect only main flow to execute, not both of them.

For the second constraint I tried all available combinations, but I always get both flows evaluated and executed.