O'Reilly logo

Pro SQL Server 2012 Integration Services by David Dye, Michael Coles, Francis Rodrigues

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

C H A P T E R  9

Variables, Parameters, and Expressions

Old expressions are the best, and short ones even better.

—Prime Minister Winston Churchill

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 ...

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