Chapter 9. Using Expressions


In This Chapter

  • Expression Basics

  • Property Expressions

  • Data Flow Property Expressions

  • Variable Expressions

  • Precedence Constraint Expressions

  • For Loop Expressions

"IT'S IMPOSSIBLE TO OVERSTATE JUST HOW POWERFUL EXPRESSIONS CAN BE IN AN SSIS SOLUTION. GOTTA BE MY FAVORITE FEATURE OF SSIS, I RECKON."

JAMIE THOMSON

Package expressions are a feature that allows simple expressions to be used in various parts of a package. They are a very important feature of Integration Services because they simplify packages by facilitating surgical, intelligent, dynamic, and subtle adjustments to the flow and settings of the package. Understanding how to use expressions is critical to creating effective packages and getting the most from Integration Services. This chapter is a gentle introduction to package expressions. Appendix B, "Expression Syntax and Cookbook," covers more detailed descriptions of expression evaluator functions and syntax.

The expression syntax is a combination of operators and math, string, and T-SQL like functions. See Appendix B for a listing of the expression functions and operators. Expressions can use package variables and can perform useful functions, such as concatenating strings, calculating dates, building unique filenames, or generating unique numbers. Package expressions can be found on virtually every object in Integration Services, but how they are used and when they are evaluated is different depending on where the expression is found. There are several types of package expressions, as follows:

  • Property expressions

  • Data flow property expressions

  • Variable expressions

  • Precedence constraint expressions

  • For Loop expressions

  • Data flow transformation expressions



Microsoft SQL Server 2005 Integration Services
Microsoft SQL Server 2005 Integration Services
ISBN: 0672327813
EAN: 2147483647
Year: 2006
Pages: 200
Authors: Kirk Haselden

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net