Assigning SSIS Expressions
In some ways, I've saved the best for last; SSIS has the ability to configure expressions for nearly every control flow task type property value. You learned earlier in this chapter that SSIS expressions could be used in conjunction with control flow precedence constraints; they can also be used with particular control flow tasks. So why are expressions associated with tasks or components so wonderful? These expressions can be assigned to most any read/write property in the entire SSIS package, which, in effect, enables dynamic update of the associated property at runtime. Figure 8–43 shows the interface for expression definition using the Execute SQL control flow task.
Figure 8–43. The Expressions section of control ...
Get Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
