Hi - I have used pkg configs successfully at other employers (configs for each db and then an
environment variable for MACHINENAME to get server name). It all worked beautifully.
Now I am at a new employer and have a problem (I think):
I am using SSIS 2008, and am using SSIS config in SQL Server table (not xml).
Have set up the configs for each db for connection string property, no problem.
But...I have 1 server (SQLDEV is the name) that has 2 instances on it: SQLDEV and SQLQA.
These are VM btw. They set up 2 instances so I could test my deployment and so on and also
have users test the data on QA.
How can I set up a configuration for the server name AND instance so I dont have to
make copies of all my packages and re-set the connections for the dbs?
That's problem 1.
Problem 2 is:
I also have a situation for staging packages that currently live on the SQLDEV box (SQLDEV instance).
The source data is coming from the AS400 dev box whose library name is "LANSADVL"...so far so good.
BUT - when I want to deploy these pkgs to my prod box and pull source data off the PROD AS400 - its library
name is "MBM". So, how do I set up configs in this situation? It seems similar, yet different from
Problem # 1 above.
Any suggestions most helpful...don't want 5000 copies of each SSIS pkg