Summary

Two data flow components rely on expressions. The Derived Column and the Conditional Split transforms use expressions to determine how they should handle data. These components are covered in detail in Chapter 20, "The Stock Data Flow Components."

Expressions are important in Integration Services. This chapter has shown the power and flexibility package expressions bring to the table. Take some time to learn expressions well and it will pay off in simple, manageable, and powerful packages. The total number of operations and functions in expressions is fairly limited, which makes it easy to quickly get up to speed. Yet, when combined with variables and placed strategically within your package, expressions provide a simple and elegant way to control packages.