Click here to Skip to main content
14,382,360 members
Rate this:
Please Sign up or sign in to vote.
See more:
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.
Posted

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

   

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




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100