Make 1 Variable accessable by 3 Packages

Hi Experts,
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
Niall GallagherDeveloperAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim HornMicrosoft SQL Server Data DudeCommented:
If you're running SSIS 2012 or greater you can use the Project Deployment Model to scope variables at the Project level, usable by all packages.

I've also seen a lot of places where SSIS connection info is stored in a table, often encrypted, and SSIS packages make a call to that table to get connection info, assign the values to variable(s), then the connections are driven by those variable(s).

Good luck.
Jim
Niall GallagherDeveloperAuthor Commented:
Jim,
Thanks for your response and I tried to use the deployment manager  already but not for this and as my Dev server is only 2008 it just stayed greyed out, so I changed the server to a 2012 server just to see what would happen and it became active but then complained that it couldn't find the (SSISDB).

The second option is possible and I will talk to the other guys about it and see how they feel, but it is definitely an option.
Thanks
nishant joshiTechnology Development ConsultantCommented:
Project level variable is only available with SSIS 2012.So each package can share it's details.But if you want to accomplish using SSIS 2008 - You can create one configuration file.

Configure all 3 package to use same configuration xml file.Keep your connection string in this file.

May shared configuration between all 3 package will solve your problem.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Niall GallagherDeveloperAuthor Commented:
@nishant,
The configuration file I would be very interested in and I will search my knowledge base (Google) for more info, but if you know of any good sites with more info on both SSIS 2012 and SSIS 2008 it would be greatly appreciated.
Thanks
Vitor MontalvãoMSSQL Senior EngineerCommented:
Niall292, do you still need help with this question?
Niall GallagherDeveloperAuthor Commented:
I have not tried it yet because I was put on another project but it seems the most plausable
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.