• The best way to do this is with package configurations for your connections. Each server can have its own configuration table/file indicating the appropriate connection string for each connection. Google SSIS Package configurations and do some reading. It should make sense without too much time.

    Package configurations are also very useful for changing variables in different environments such as date ranges or distribution lists, etc.. You simply maintain the configurations and you don't have to change the package itself.