As Lyn suggested you can do this by changing the value in a script.

Another way I have handled this (without using script) is to call a child package where it inherits the value of the server/connection string from the parent package.

I tend to this sort of Process Controller Package, and Child Process package quite a bit as it gives some structural separation between different packages and can give a lot of flexibility.