Click here to Skip to main content
15,881,687 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
can some one tell me how to run dynamic query of SQL using parameters in SSIS

Already did in SSMS
SQL
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:
SQL
Select 'ABR_temp.dbo.Clist' as Table1

-Result Set-
Result Name=Table1
Varibale Name=User::Table1

---------------------
Execute SQL Task Box 2

SQL Statement:
SQL
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.
Posted

1 solution

 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900