Post reply

SSIS

  • November 5, 2009 at 8:26 pm

    #217154

    Here is my scenario.

    I have different set of SSIS packages for each module.

    When am deploying the first set of packages (1st module), I need to create two environment

    variables for config file path and root directory path.

    Now, when am going to deploy all other modules, I need to create 2 environment variables for each module. If I have 5 modules to deploy I end up creating 10 environment variables to specify the config file path and the root directory path where SSIS packages exist.

    Is there any other way of doing this without creating these many variables?

    Any kind of suggestions would be a great help!

    Thanks

  • November 5, 2009 at 8:54 pm

    #1075691

    I'm a little fuzzy why you would implement it this way.. Your root directory path should be IN your config file. So you should need one environment variable per config file.

    I would ask a question first though..

    How are the packages called SQL Agent?

    If so then you don't need ANY environment variables. You can specify then in the SQL Agent job. Why don't you elaborate on how they will be called.

    CEWII

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

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