Hi what is environmental variable in package configuration

Hi what is environmental variable in package configuration

Read: http://support.microsoft.com/kb/310519 It will allow to setup configuration once per server.

Read this ,Hope should be helpful http://www.jasonstrate.com/2011/01/31-days-of-ssis-environmental-variable1731/

You can also use it to manage ssis connection information centrally: http://randypaulo.wordpress.com/2011/12/02/ssis-centralize-connection-repository/Randy Aldrich Paulo MCTS(BizTalk 2010/2006,WCF NET4.0), MCPD | My Blog BizTalk Message Archiving - SQL and File Automating/Silent Installation of BizTalk Deployment Framework using Powershell > Sending IDOCs using SSIS

Hi suresh Nelluri, Environmental variables allow variables to be specified and set within an operating system environment. The value is available to all applications and exists from one reboot to another. When environmental variables are used properly with SSIS packages, they can be deployed to any environment and perform within the confines of that environment. For more information about it, please see: http://www.jasonstrate.com/2011/01/31-days-of-ssis-environmental-variable1731/ Thanks, Eileen

Please note: Do not confuse yourself with "Environments" which is introduced in 2012, as a new feature for SSIS. For more info: http://mikedavissql.com/2012/05/02/ssis-2012-copy-or-duplicate-environments/Please vote as helpful or mark as answer, if it helps Cheers, Raunak | t: @raunakjhawar | My Blog