Tony Oswald
asked on
SSIS Precedence Contraint isn't processing
I have an SQL task that selects the count of records, and the result is returned to a variable, ServiceExists.
I have set 2 precedence contraints to go to 2 different tasks, based on the value of the variable, one is @[User::ServiceExists] > 0, and the other is @[User::ServiceExists] == 0.
The flow works when the count is > 0, but when it is 0, it stops.
can anyone tell me why?
I have set 2 precedence contraints to go to 2 different tasks, based on the value of the variable, one is @[User::ServiceExists] > 0, and the other is @[User::ServiceExists] == 0.
The flow works when the count is > 0, but when it is 0, it stops.
can anyone tell me why?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Gotta love how intuitive SSIS expressions are.
Thanks for the grade. Good luck with your project. -Jim
Thanks for the grade. Good luck with your project. -Jim
ASKER
thanks!!