I experienced the bug whereby one is unable to add parameters to sql text that one has ? (question marks) in. This seems like a well documented bug and I was unable to get around it by rearranging the sql command in various ways.
So I instead went to doing a variable (string), and using data flow source as "SQL command from variable". But then when i select my variable, of course, I end up with Error ... command text was not set for the command object". Well of course it's not, the package hasn't run yet.
how do I get around this seeming dichotomy? And yes I have the variable set to EVALUATE AS EXPRESSION. but since it's not filled yet.. ?