SSIS 2012 Parameters vs. Configurations
Special thanks to our friends at GDH Consulting for hosting the meeting.
In this session, SQL Santa (Allen) will review configurations in SQL 2008R2. These options allowed dynamic configuration across environments. Next, we look at SSIS 2012 and the new dynamic options, including Parameters, Expressions and Variables. This upgrade takes SSIS from simply confusing to downright confounding. We will simplify these options so any elf in the workshop can follow along.
SQL Integration Server developers need to make dynamic changes to properties and connections when moving packages across environments.
‘Configurations’ enabled SQL Integration Services 2008 R2 developers to make those changes, but it could be very confusing when multiple Configurations were used in combination.
SQL Integration Services 2012 maintains support for Configurations while adding a lot of power and versatility with Parameters, Environments and Variables.
Professional Microsoft SQL Server 2012 Integration Services
by Brian Knight, Erik Veerman, Jessica M. Moss, Mike Davis, Chris Rock
2008R2 – Defining a Configuration Approach
2012 SSIS Parameter Basics
2012 SSIS Catalog Basics and list of stored procedures