configuring ssis pakage for environmental variable

  • I want proper steps to configure package for environmental variable and deploy that package and run it on another machine so it will use config from environmental variable.

  • Understanding Integration Services Package Configurations

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • What tool you are using to design packages? SSIS 2008/2008R2/2012.

    As per my experience you should always create environmental variables as System Variables.

    Vikash Kumar Singh || www.singhvikash.in

  • Vikash Kumar Singh (5/14/2013)


    What tool you are using to design packages? SSIS 2008/2008R2/2012.

    As per my experience you should always create environmental variables as System Variables.

    First point to note is that they're called 'environment' variables, not environmental - these won't help us with climate change.

    The link provided by Koen provides all the details - look for the parts which refer to 'indirect' configuration.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • One caution I want to throw out here - environment variables are NOT instance aware. That is if you have 2 (or more) instances of SQL Server on the same installation of windows, they will all share the environment variables. This one bit me when I took over some SSIS from a contractor and the QA and UAT instances were on the same windows server.

  • Uripedes Pants (5/15/2013)


    One caution I want to throw out here - environment variables are NOT instance aware. That is if you have 2 (or more) instances of SQL Server on the same installation of windows, they will all share the environment variables. This one bit me when I took over some SSIS from a contractor and the QA and UAT instances were on the same windows server.

    Another related issue is that you can't install multiple instances of SSIS on one server, so that one SSIS has to share QA and UAt as well.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 6 posts - 1 through 5 (of 5 total)

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