Using the Premium Expression Task

The Premium Expression Task is a control flow component that can be used to evaluate an expression and assign the result to a variable during runtime.

Premium Expression Task

List of Variables
Drag and drop a variable from the tree view to the Expression column to add a variable to your expression.
List of Functions
Drag and drop a function, cast, or operator from the tree view to the Expression column to add a function to your expression. Information about the selected function will appear in the panel below. See a full list of the available expressions and their description below.
Search For Function
Filter the list of functions.
Expression fx Button
Clicking the fx button to launch SSIS Expression Editor to enable dynamic update of the property at run time.

Error Handling Page

Premium Expression Task - Write error to variable

The Error Handling page allows you to specify how errors should be handled when they happen. There are three options available:

  1. Fail on error
  2. Write error to variable - This can be used to assign the error to a variable at runtime
  3. Ignore error

Expression Editor

The Expression Editor offers a multi-line colored textbox to construct more complex expressions. Expressions can also be tested using test values for column data.

Premium Expression Task - Expression Editor

List of Columns & Variables
Drag-and-drop a column or variable from the tree view to the Expression column to add a column or variable to your expression. Below the list of columns, there is a panel with details about the selected variable or column. When a column is selected you can change the value of the Test Value. This is the value that will be used when the expression is tested.
List of Functions
Drag-and-drop a function, cast, or operator from the tree view to the Expression column to add a function to your expression. Information about the selected function will appear in the panel below.
Search for Function
Filter the list of functions.
Expression Textbox
The expression that will be evaluated for each row.
Validate
Validates the expression using test values. Any errors will appear in the error box below.
Test
Tests the expression using test values and displays the result in a message box.