I'm getting the syntax error below when I try to use a variable for AS400 (iSeries) selects. When I type the command in directly it works fine.
I'm just surrounding the SQL in quotes and changing my OLE Db Source to variable. My variable has been set to Evaluate Expression = True.
Thanks for any help you can lend me.