can some one tell me how to run dynamic query of SQL using parameters in SSIS
Already did in SSMS
DECLARE @Table1 NVARCHAR(100) = 'ABR_temp.dbo.Clist'
DECLARE @query NVARCHAR(max)
SET @query = 'Select * from ' + @Table1
EXEC (@query)
here is the problem
----------------------
Execute SQL Task Box 1
SQL Statement:
Select 'ABR_temp.dbo.Clist' as Table1
-Result Set-
Result Name=Table1
Varibale Name=User::Table1
---------------------
Execute SQL Task Box 2
SQL Statement:
Select * from ?
-parameter mapping-
Variable name: User::Table1
Parameter name: 0
ERROR is
--------
Error: 0xC002F210 at Execute SQL Task 2, Execute SQL Task: Executing the query "
select * from ?" failed with the following error: "Syntax error, permission violation, or other nonspecific error". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.