Use Integration Services Environments to Set Multiple Values with a Single Selection when Scheduling SSIS Packages
In my last SSIS blog I explained how to easily set the value of a single parameter at execution time. Here we look at how to take a set of parameter values that may often be used together depending which mode you want to run your job in. The classic usage of this is the choice of production environment (development, test, QA, production etc) where you want to output to a different database, potentially with a different logon, or possibly importing different source files, depending on the mode you want to run the job in.
