Greg J (10/11/2012)
Picture will explain all. I can't figure out how to assign a User::Variable in my Data Flow custom source command.
This works in 2008R2, and it gives me a generic syntax error in 2012. THOUSANDS of people must be doing this already... What am I doing wrong here?
I usually use a variable instead of parameters inside the source component. It can be a bit buggy, as you've noticed.
The article proposed by Ray uses a script task to construct the SQL Statement, but I wouldn't go that for. An expression on the variable itself suffices.