September 2012
Intermediate to advanced
444 pages
12h 17m
English
book
SQL Server 2012 Integration Services Design Patterns
by Andy Leonard, Matt Masson, Tim Mitchell, Jessica M. Moss, Michelle Ufford
Content preview from SQL Server 2012 Integration Services Design Patterns
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
CHAPTER 18
Configuration
SQL Server 2012 introduces Parameters – a new 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. While 2005/2008 style Package Configurations are still supported in SQL Server 2012, the two configuration models are not meant to be mixed. In fact, the menu option to use them will only appear when using the File Deployment Model, and on packages that have been upgraded from previous versions. New packages created in 2012 will use the new Parameter model by default.
This chapter describes the new Parameter ...