Does anyone have an example of how to use a SSIS variable in an openquery stmnt. I am having a hard time finding a way to pass the variable to the openquery.
Thanks,
SQL Server Integration Services
Does anyone have an example of how to use a SSIS variable in an openquery stmnt. I am having a hard time finding a way to pass the variable to the openquery.
Thanks,
Instead of passing the variable to the openquery, can the openquery become part of the variable so the entire sql statement is stored in the variable You can then execute sql command from a variable.