If any one knows how to use variable in SSIS data flow source task using OLE DB connection.kindly help me on this
Query in my data flow source task
declare @id int
select @id,column1 from my_tablename
The above query throwing the following error
TITLE: Microsoft Visual Studio
Parameters cannot be extracted from the SQL command. The provider might not help to parse parameter information from the command. In that case, use the "SQL command from variable" access mode, in which the entire SQL command is stored in a variable.
Syntax error, permission violation, or other nonspecific error (Microsoft SQL Server Native Client 11.0)