I'm experiencing a frustrating issue when trying to call a proc in an OLE DB source task. I'm using the SQL command from variable data access mode but I can see that it isn't evaluating my variable correctly.
My variable (with ValidateAsExpression set to True) uses an expression to create a sql command like "EXEC ProcName 'Param'" where the value of Param comes from a variable who's value I set using an EXEC SQL task. Below is the expression:
"EXEC ProcName " + "'" + @[User::vDateThreshold] + "'"
If I use a variable in my source that references a static value it works fine, but the issue seems to be when I use a variable which reference another variable in its expression.
Has anyone else come across this issue?
I'm using this method because I've had a similar issue when trying to use a parameter with the sql command data access method.
Thanks in advance