I have a package that has Execute SQL task. SQL Statement assigns a value to a variable iFlowVar (values are 1, 2 , or 3).
I have 3 subsequent DataFlow tasks DF1, DF2, and DF3.
I need to
execute DF1 only if iFlowVar = 1 | and not execute DF2 and DF3.
execute DF2 only if iFlowVar = 2 | .....
execute DF3 only if iFlowVar = 3 | .....
What is the best way to achieve this? Its an equivalent of multiple IF statements in any programming language.