• 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.