• 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.