Uripedes Pants (5/15/2013)
One caution I want to throw out here - environment variables are NOT instance aware. That is if you have 2 (or more) instances of SQL Server on the same installation of windows, they will all share the environment variables. This one bit me when I took over some SSIS from a contractor and the QA and UAT instances were on the same windows server.
Another related issue is that you can't install multiple instances of SSIS on one server, so that one SSIS has to share QA and UAt as well.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP