SSIS 2012 Parameters vs. Configurations

Attached is tonight’s presentation ‘SSIS Param VS Config‘ from the Oklahoma City SQL User’s Group.

Special thanks to our friends at GDH Consulting for hosting the meeting.

Abstract:

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.

References:
Professional Microsoft SQL Server 2012 Integration Services
by Brian Knight, Erik Veerman, Jessica M. Moss, Mike Davis, Chris Rock
2008R2 – Defining a Configuration Approach
http://msdn.microsoft.com/en-us/library/cc671625.aspx
2012 SSIS Parameter Basics
http://msdn.microsoft.com/en-us/library/hh213214.aspx
2012 SSIS Catalog Basics and  list of stored procedures
http://msdn.microsoft.com/en-us/library/hh479588.aspx

Tags: Integration Services, Presentations, SQL 2008 R2, SQL 2012, SSIS