I created 2 variables
1) @[user::var] of type int,initialize with 0 and updated at runtime
2) @[user:sSQL] of type string and value is Select column1 from table1 where column1 > @[user::var] and I set the property EvaluateAsExpression to true
I am using @[user::sSQL] in an Oledb source component,when I run my package I validate that @[user::var] gets updated but the updated value does not pass through to the @[user::sSQL] rather @[user::sSQL] still has 0 instead of the updated value.
How do I make the dynamic sql to use the updated @[user::var]?
I will greatly appreciate a quick response.
asked Apr 14 '10 at 12:40 PM in Default
When you have the variable and the expression, have you validated the expression in the expression builder?
Also, could you include the exact text that is in your variable? In my experience there should be double qoutes around the text and the variable should be outside those quotes, like this;
"Select column1 from table1 where column1 > " + @[user::var]
Also, make sure that the variable user::var is in scope
answered Apr 15 '10 at 01:30 AM