Export (0) Print
Expand All
0 out of 10 rated this helpful - Rate this topic

Expression Task

SQL Server 2012

The Expression Task creates and evaluates expressions that set variable values at runtime, using the Expression Builder. When you edit the task, the Expression Builder is launched.

The expression language includes functions and operators. For examples that demonstrate how to use the functions and operators, see the Expression Examples sections in the functions and operators topics. Links to the topics are in Functions (SSIS Expression)and Operators (SSIS Expression).

For examples of more complex expressions, see Examples of Advanced Integration Services Expressions.

For examples of using expressions to set properties, see the Sample Property Expressions section in Use Property Expressions in Packages.

Technical article, SSIS Expression Cheat Sheet, on pragmaticworks.com

Integration Services icon (small)  Stay Up to Date with Integration Services

For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN:


For automatic notification of these updates, subscribe to the rss feeds available on the page.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.