Task Factory
"I have found Task Factory to be a huge time saver with SSIS development. The SalesForce components alone saved close to two months of work on a major integration project. I highly recommend!"
Alan Rubel
Database Administrator
Joint Commission Resources
Task Factory Loews Corporation
"We bought the product mostly because of the company's reputation for the service they provide and the specific need of a secure SFTP task."

Matt Cushing

Application Systems Analyst/Developer

Loews Corporation

Greater New York City Area

Task Factory - Jay Cole
"I purchase Task Factory over a year ago, and let me tell you, IT WORKS FLAWLESSLY. I haven’t had a single problem with it, and I used to HATE having to make changes with the version you’re using. My advice (for what it’s worth) is to pay the money!"

Jay Cole

Task Factory - Mark Marinovic
"We bought Task Factory primarily for the SCD Type 2 task, as it enabled us to do several things the built-in SSIS SCD task did not do. Task Factory comes highly recommended from me as our ROI was reached in just days."

Mark Marinovic

Task Factory - Urban Outfitters
"We have found that Task Factory tremendously speeds up the development process and improves performance by means of the high-performance components."

Tim Harris

BI Data Engineer

Urban Outfitters Inc.



Buy Now Free Trial Download Compare Editions More Features

Task Factory Advanced Derived Column

The Advanced Derived Column extends and replaces the native SSIS Derived Column to allow the user to use our expanded Expression Engine and its 180+ functions to create new columns in your dataflow.

Feature Highlights

  • Extended Expression Library allows the user to create new conditions based on expressions not available in SSIS.
  • Expression Engine supports multi-line expression which allows for more complex conditions to be created.
  • Unit Tester that comes with the expression editor allows the user to test the condition expression before running the package.
  • Expression reusability allows the user to define an expression and reuse it in other derived conditions.
Advanced Derived Column

Advanced Derived Column- Step 1
The Advanced Derived Column allows users to access many more functions and operators than the native derived column transform. The configuration is similar to an expression editor.

The Advanced Derived Column allows users to access many more functions and operators than the native derived column transform. The configuration is similar to an expression editor.

Advanced Derived Column- Step 2
First, provide a name for the new column. Build the expression in the expression field using the available columns and selection of functions and operators. This transform has a total of 187 functions to choose from; much more that the native derived column transform.

First, provide a name for the new column. Build the expression in the expression field using the available columns and selection of functions and operators. This transform has a total of 187 functions to choose from; much more that the native derived column transform.

Advanced Derived Column- Step 3
Check the expressions by clicking ‘Validate All’ at the bottom of the editor.

Check the expressions by clicking ‘Validate All’ at the bottom of the editor.

View Our Suite of Pragmatic Works Products
Copyright 2014 by Pragmatic Works