SSIS Precedence Contraint isn't processing
Posted on 2013-09-20
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?