locked
Do we have to create the environment variable for package configuration? RRS feed

  • Question

  • Hi, gurus,

    I just wonder do we have to create the environment variable for package configuration files? Is it that if we dont have a environment variable set up for the configuration file then the package wont be able to pick up the settings specified within the configuration files? Cos the pain for setting environemnt variable is whennever you create a new environment variable you will have to restart the machine where the environment variable is created.

    Thanks a lot in advance and I am looking forward to hearing from you shortly.

    Best regards,

    Yours sincerely,

     

    Tuesday, September 9, 2008 10:21 AM

Answers

  • No you do not have to set up an environment variable for package configurations.  Environment variables are a type of package configuration that can be very helpful in creating an indirect configuration (http://blogs.conchango.com/jamiethomson/archive/2005/11/02/SSIS_3A00_-Indirect-configurations-ROCK_2100_.aspx), but they are not necessary.  You can simply create the configuration xml file / sql server / registry setting with no need to create the environment variable.

    By the by, you don't need to restart the machine, although it is handy to tell people that they need to restart as this will create less of a headache than trying to walk through any processes which might be keeping that environment variable in scope, and thus not updated. 
    Tuesday, September 9, 2008 12:19 PM

All replies

  • No you do not have to set up an environment variable for package configurations.  Environment variables are a type of package configuration that can be very helpful in creating an indirect configuration (http://blogs.conchango.com/jamiethomson/archive/2005/11/02/SSIS_3A00_-Indirect-configurations-ROCK_2100_.aspx), but they are not necessary.  You can simply create the configuration xml file / sql server / registry setting with no need to create the environment variable.

    By the by, you don't need to restart the machine, although it is handy to tell people that they need to restart as this will create less of a headache than trying to walk through any processes which might be keeping that environment variable in scope, and thus not updated. 
    Tuesday, September 9, 2008 12:19 PM
  • Hi,

    Thanks a lot for your help.

    Best regards,

     

     

    Tuesday, September 9, 2008 2:29 PM