Configuration - SQL Server Integration Services Design Patterns - page 405

Setting expressions for data flow components is less straightforward than setting
them on tasks. The main differences are that the expressions are set on the Data Flow
task itself and that not all component properties are expressionable. Figure 17-5 shows
how expressionable properties on a Lookup transform “bubble up” and appear as prop-
erties on the Data Flow task.
Figure 17-5 . Expressionable data flow component properties will show up as properties on the Data Flow task
Package and project-level parameters will appear in all of the UIs that display the
list of available variables. On the Expression Builder dialog ( Figure 17-6 ) , all paramet-
ers appear under the Variables and Parameters folder.