O'Reilly logo

Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition by Guy Fouché, Lynn Langit

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

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

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