I am trying to control execution flow in SSIS using variables to disable steps. Essentially I have one script task which based on a test sets one boolean variable to true/false, I then want to execute one task if the variable is true and another if the variable is false. This is all in the Control Flow.
I have tried two variables and setting them in the script task but this causes an error which I cant fix. I have also created two variables and tried to set the second one based on an expression but that doesnt return an error that I can translate either.
Can anyone suggest an option?
So people can answer a little easier script task is called "CheckConnections", variable 1 is called "RetrieveDisable" and variable 2 is called "LogDisable"
Cheers