Forum menu
Topic starter
trying to get a constraint to work. I have created an sql task, it produces the number 1 or 0 cast as a bit.
I have created a variable that is populated by this and set this to Boolean.
I have then placed a constraint between two steps based on the variable being = true,
It doesn't work. any hints please.
Posted : 24/02/2016 5:10 pm
Are you using an Evaluation Operation? This should be Expression and Constraint i.e. the execute SQL task should suceed and resolve to true.
If you just use a constraint your options are sucess, failure and completion, which probably ignores your varible being true.
Just to caveate this - I am in no way an SSIS developer, so might be talking out of my backside 😀
Posted : 24/02/2016 8:23 pm