Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SSIS Precedence Constraint Expression not working

I have an int variable User::FileLineCount scoped in a for loop container and in a task within the loop, I want to proceed from the task depending in this variable's value.

In the Precedence Constraint Editor I have chosen Evaluation Operation as Expression and the Expression as @FileLineCount!=0. There is another version to some other task as @FileLineCount==0. When I debug, I can see that the User::FileLineCount value is 0 but when I step Over the task I get Unable to step. Not Implemented. error.

Thanks for the help

EDIT: Apparently the debugger could not step over so that was the reason for the error but the conditions still do not work properly.

EDIT2:One constraint

The other one is @FileLineCount==0. Doesnt work without OR'in as in the picture.

like image 852
mechanicum Avatar asked Jan 25 '26 00:01

mechanicum


1 Answers

I had two paths leaving a data flow task one would go to a sql task and the other would go to another task. I was struggling with this until I realized that two paths leaving the same data flow task would be an or if they were different paths. I assume that you would use AND if you had multiple tasks going into one task and you needed them all to be true for it to proceed. I'm not sure if this exactly what you are asking.

enter image description here

This would be or, because I want one or the other.

Where below I want all three to be true to continue to send the email.

enter image description here

like image 112
George Avatar answered Jan 27 '26 22:01

George