Abstract
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 is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2012 Andy Leonard, Matt Masson, Tim Mitchell, Jessica M. Moss, and Michelle Ufford
About this chapter
Cite this chapter
Leonard, A., Masson, M., Mitchell, T., Moss, J.M., Ufford, M. (2012). Configuration. In: SQL Server 2012 Integration Services Design Patterns. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-3772-3_18
Download citation
DOI: https://doi.org/10.1007/978-1-4302-3772-3_18
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-3771-6
Online ISBN: 978-1-4302-3772-3
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books