Within SSIS - Is it possible to deploy one package multiple times in the same instance and set diffe
Posted
by Matt
on Stack Overflow
See other posts from Stack Overflow
or by Matt
Published on 2010-05-07T14:36:49Z
Indexed on
2010/05/07
15:58 UTC
Read the original article
Hit count: 144
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.
© Stack Overflow or respective owner
