Configuration - SQL Server Integration Services Design Patterns - page 404

Figure 17-3 . The Property Expressions Editor dialog shows all properties that have expressions set on them
Expressions can be set on variables directly from the Variables window (as shown
in Figure 17-4 ). In SQL Server 2012, adding an expression to a variable automatically
sets its EvaluateAsExpression property to True —in previous versions of the
product, you had to perform this step yourself. You can disable expression evaluation
for a variable by setting this property back to False .
Figure 17-4 . Expressions can be set directly from the Variables window in SQL Server 2012. Variables that have an
expression set on them appear with a special icon
Figure 17-4 also shows a new feature in SQL Server 2012—expression adorners.
The icons for tasks, connection managers, and variables will change if any of the ob-
ject's properties are set via expression, providing a visual way for a developer to identi-
fy which parts of a package are being set dynamically.