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.
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.
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.
Note: If the Task Factory component doesn't have an Expressions button:
- Right click the task.
- Select Properties.
- Select into the Expressions option to enable the ellipsis button.
- Select the ellipsis button to launch the 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):
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.
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:
- Drag the ISNULL function into the Expression box
- Drag the System::CancelEvent system variable into the <<expression>>
- Select Evaluate Expression to verify the syntax and expression
- Select OK to complete building the expression
Success: You've built an expression!
Note: Select the on the next line to add another expression.
Highlight an expression, then select Delete to remove it: