 You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
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.
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 😀