Firstly I have to ask is this even possible.
I have 3 SSIS Packages in one Solution (I'm not sure of the proper name in BIDS) and each of them use the same server and the same DB.
Each Package needs its own Connection and I have put the Server name in the connection as a variable (Thinking it would save a lot of time, but I was wrong) I still have to change the variable value for each Package.
Is there a way I can connect the variable up to look at a global value so all 3 package connections get updated. The reason I do this is when in Development I hit the Dev servers and then I can change to value for production to hit the production servers.
Thanks in advance and I hope the question is not totally off the wall