Task Factory Expressions

 Task Factory users running version 2020.1.4 or older (released prior to May 27, 2020): There's an important Task Factory update. Please visit here for more details.

Unsupported: The Property Expressions Editor and Expression Builder are launched from Task Factory as a convenience, but they are not part of the Task Factory software. This article shows how they are accessed from Task Factory and provides a simple example of linking them to the options available for the Task Factory component. Please refer to official Microsoft documentation for assistance with these SSIS features.

Introduction

Some components have an Expressions button which allows you to build expressions with the property values associated with the task. It uses values in the package with the operators and functions that are available as part of the core SSIS engine. This allows you to build expressions without having to leave the dialog to configure them.

Note:  If you're looking for information about the Expression task, see the Task Factory Expression article.

Expressions

The expressions are built using native expressions in SSIS.

Additional Information: For help with using native expressions in SSIS, see the Integrations Services (SSIS) Expressions article from Microsoft Docs.

Property Expressions Editor

Additional Information: For help with using the Property Expressions Editor, see the Use Property Expressions in Packages article from Microsoft Docs.

Select the Expressions button to open the Property Expressions Editor.

Property Expressions Editor

The Property Expressions Editor provides the ability to parameterize any of the options available for the Task Factory component (in this example, the Secure FTP Task):

Property options

Expression Builder

Additional Information: For help with the Expression Builder, see the Expression Builder article on Microsoft Docs.

Select the to open the Expression Builder. This allows you to set properties of SSIS tasks dynamically based on values in the package.

Expression Builder

Building Expressions

Additional Information: See the following articles on Microsoft Docs for help with the System Variables, Functions, Operators, and Casting:

Drag and drop the options to build an expression. For example: 

  1. Drag the ISNULL function into the Expression box 
  2. Drag the System::CancelEvent system variable into the <<expression>>
  3. Select Evaluate Expression to verify the syntax and expression
  4. Select OK to complete building the expression
Drag a function into the Expression
Build, evaluate, and complete the Expression

Success: You've built an expression!

Note:  Select the on the next line to add another expression.

Deleting Expressions

Highlight an expression, then select Delete to remove it: