SQL Server Performance

Package Confiuration User Envirment Variable

Discussion in 'SQL Server 2005 Integration Services' started by dineshasanka, Jun 8, 2007.

  1. dineshasanka Moderator

    Even though I got this issue in SQL Server it is not a SQL Server question.

    I need to create a user envirment variable to store XML file path of the package configuration.

    How can I create a user envirment variable via bat file.

    PN If I use SET command it creates a system envirment variable


    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/
  2. satya Moderator

    Another blog<a target="_blank" href=http://dotnetjunkies.com/WebLog/appeng/archive/2006/05/30/indirectconfigpackagessis.aspx>http://dotnetjunkies.com/WebLog/appeng/archive/2006/05/30/indirectconfigpackagessis.aspx</a> for you [<img src='/community/emoticons/emotion-1.gif' alt=':)' />].<br /><br /><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Writer, Contributing Editor & Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing. <hr noshade size="1">Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.</i></font id="size1"></font id="teal"></center>
  3. dineshasanka Moderator

    thanks for the link

    but what i need is to create user envirment variales from a batch file

    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/

Share This Page