yes, it appears I will have to manually change that ini file for deployment to each instance
on the SQLDEV box.
However, I am not sure that will solve my problem....once they are deployed and I
want to run them (via sql agent) how will the packages know that the connections
should point to the instance? LIke, I have a connection called "MDS", in the setting I had
to specify the server and instance and db(SQLDEV box, SQLDEV instance, MDS db).
As I said in the 1st posting, in previous life I had an environment variable ON the servers
for the MACHINENAME and was able to reference this in my package configs so It knew
which box to use (and subsequently which db).
The problem #2 is similar, but different.
THe staging packages pull data off the AS400 source system.
On my SQLDEV box I want to pull from the DEV AS400 (whose library name is "LANSADVL", box
name is "DVL").....but for production I want to read from MBM box with library name "MBM".
I dont see how I can achieve this without copying the staging packages and opening
each one and modifying the connections.