SSIS Catalog: How to use environment in every type of package execution
- by Kevin Shyr
Here is a good blog on how to create a SSIS Catalog and setting up environments. http://sqlblog.com/blogs/jamie_thomson/archive/2010/11/13/ssis-server-catalogs-environments-environment-variables-in-ssis-in-denali.aspx
Here I will summarize 3 ways I know so far to execute a package while using variables set up in SSIS Catalog environment.
…