patd1
asked on
SSIS use database name as a parameter to sql task
Creating an SSIS packege. Is it possible to create a sql task that runs a query that uses database name as a parameter?
example : Insert into mydb.ssis.mytable1
Values
(Select * from ?.prod.mytable1)
The parameter values should be coming from a user variable. Is that possible?
Thanks.
example : Insert into mydb.ssis.mytable1
Values
(Select * from ?.prod.mytable1)
The parameter values should be coming from a user variable. Is that possible?
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Or, perhaps, a better approach might be to use variables in the ConnectionManager for the Instance and catalog settings.
Just add Expressions in a variable and it will do.