O'Reilly logo

SQL Server Integration Services Design Patterns, Second Edition by Michelle Ufford, Jessica Moss, Matt Masson, Tim Mitchell, Andy Leonard

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 17

image

Configuration

SQL Server 2012 introduced a new, parameter-based configuration model for SSIS. This new model is meant to simplify the configuration process and make it easier for users to identify where values are coming from at runtime. Although 2005/2008-style package configurations are still supported in SQL Server 2012 and SQL Server 2014, the two configuration models are not meant to be mixed. In fact, the menu option to use them will only appear when you are using the file deployment model and on packages that have been upgraded from previous versions. New packages created in SQL Server 2014 will use the new parameter model by ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required