Post reply

How to set the environment variables for SSIS package

  • June 17, 2012 at 11:51 pm

    #262415

    Hi,

    I need to set the environment variables for SSIS package.

    The thing is that we need to use Command Prompt to set the environment variable(Not My computer -> Advanced).

    Could you please let me know how to do it?

    Regards

    SqlStud

  • June 19, 2012 at 12:12 am

    #1502582

    You may use the SETX variable value command in a DOS or CMD batch file or console; I did not try this on a secured environment, it does work on my workstation, here is the code:

    @echo off

    SET X Test

    SETX Y Permanent

    ECHO %X%

    Hope this helps,
    Rock from VbCity

  • June 19, 2012 at 5:15 am

    #1502726

    Thanks Rock

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply