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 😀