MegaSack DRAW - This year's winner is user - rgwb
We will be in touch
Chat Forum
1
Posts
2
Users
0
Reactions
37
Views
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 4: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 7:23 pm