Within SSIS - Is it possible to deploy one package multiple times in the same instance and set diffe
- by Matt
In my environment my Dev and QA Database Instances are on the same server. I would like to deploy the same package (or different versions of the package) into SSIS and set the filter to select different rows in the Config table. Is this possible? This is SQL 2005.
For the sake of this question lets say I have one variable, which is a directory path. I would like to have these variables in the table twice (with different Filters applied (Dev and QA) as below (simplified) . . .
Filter / Variable Value / Variable Name
Dev / c:\data\dev / FilePath
QA / c:\data\qa / FilePath
Do I need to apply a change within the settings of the package in SSIS or is it changed on the job step within Agent?
Any help would be appreciated.