May 8, 2013 at 12:57 pm
I want proper steps to configure package for environmental variable and deploy that package and run it on another machine so it will use config from environmental variable.
May 14, 2013 at 3:44 am
Understanding Integration Services Package Configurations
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 14, 2013 at 7:23 pm
What tool you are using to design packages? SSIS 2008/2008R2/2012.
As per my experience you should always create environmental variables as System Variables.
Vikash Kumar Singh || www.singhvikash.in
May 15, 2013 at 12:51 am
Vikash Kumar Singh (5/14/2013)
What tool you are using to design packages? SSIS 2008/2008R2/2012.As per my experience you should always create environmental variables as System Variables.
First point to note is that they're called 'environment' variables, not environmental - these won't help us with climate change.
The link provided by Koen provides all the details - look for the parts which refer to 'indirect' configuration.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
May 15, 2013 at 9:57 am
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.
May 16, 2013 at 2:50 pm
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
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply