Abstract
In order to create modular and robust solutions, developers will often create variables and routines to access those variables. Integration Services is no different in this regard. The variables available to SSIS have their own data types that often correlate to SQL Server data types. Parameters are used to pass values between parent and child packages to extend the modularity of an ETL project. And an expression language is provided to allow the ETL process to read or modify the values of both during runtime. The expression language can certainly get convoluted, so it is recommended that you take Churchill’s words to heart and keep the logic minimal, readable, and easily modifiable.
Old expressions are the best, and short ones even better.—Prime Minister Winston Churchill
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2012 Francis Rodrigues, Michael Coles, and David Dye
About this chapter
Cite this chapter
Rodrigues, F., Coles, M., Dye, D. (2012). Variables, Parameters, and Expressions. In: Pro SQL Server 2012 Integration Services. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-3693-1_9
Download citation
DOI: https://doi.org/10.1007/978-1-4302-3693-1_9
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-3692-4
Online ISBN: 978-1-4302-3693-1
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books