Take data (unique IDs in a column) from excel and pass as parameters in SQL Query (Execute Query)

Help
, ,
5

Hi @oshinkavdia

You can write code like that

Declare @Query VARCHAR(8000)

Set @Query = 'SELECT * FROM tablename WHERE colum IN(' + @value1 + ', ' + @value2 + ')'

EXECUTE( @Query )

Assign it to a variable as the sql text.
Then in [Execute query] activity, set above variable to the input sql.
Notice: above sql can run correctly in SQLSERVER.