Hi, i am developing an SSIS package and I have a variable called Var. Now Var value will change as follows Var = 'Sql Server' Var = 'Oracle' Var = 'Sql query' The value of variable Var will be determined in proc which is in execute sql task and then i have 3 data flow tasks for 3 different outputs but i want to have a precedence constraint depending on the value of variable Var. so if i create variable Var and String datatype and if i try to use expression as @Var == Sql Server or @Var == Oracle or @Var == Sql query, it throws an error. Any idea how the expression should be? Thanks

I think i got it. expression should be @Var == "Sql Server" and same way for others. For now i am not getting any error for that expression but if you guys have any idea, let me know. Thanks

You've figured it out, Nick. That should work for you. Talk to me now on