HomeSQLServerPedia SyndicationEnvironment variable in SSIS not being recognized

Comments

Environment variable in SSIS not being recognized — 3 Comments

  1. We have tried multiple approaches overhere:

    – configuration value in environment variable
    – configuration value in config file
    – configuration value in config file (with environment variable pointing to config file)

    And in the end we just used variables (and override them via the /SET parameters for DtExec)

  2. I’ve run into the same issue, having changed a Environmental Variable on the Server to pick up a new data connection to UAT database, but when running the job via a SQL Server agent job, the SSIS package would not pick up the connection change. I restarted the SSIS service but still no affect, restarted the SQL Agent Job service, and the package picked up the change. Using BIDS or SSDT or Visual Studio it picked up the change OK

Leave a Reply

Your email address will not be published. Required fields are marked *

HTML tags allowed in your comment: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>