O'Reilly logo

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook by Pedro Perfeito, Reza Rad

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

Using expressions in Control Flow

Expressions provide a level of dynamism in Control Flow. Working with a Control Flow task can be much more robust when properties of the task can be set dynamically instead of having static values.

Prior to SSIS 2012, you could assign the result of an expression to a variable (writing the expression in the variable's expression property and setting the EvaluateAsExpression property of the variable to true), but problem with this method is that the value of the variable will be resolved whenever you refer the variable. For example, assume that you have a User::StartTime variable which gets the current time with the GetDate() expression function, at the end of package you want to use the User::StartTime variable ...

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