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
"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 - 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 Expression Task

The Expression Task allows you to take full advantage of the 180+ functions in our Expression Engine to set variables, call stand alone functions like CreateFile without any scripting.

Feature Highlights

  • Can set a variable without writing code.
  • Has support for replacing placeholders with data created using an expression.
  • Can call functions to perform actions like Creating Folders, Sending Emails and Writing files with a single line of code.
Expression Task

Expression Task - Step 1
Open the expression task editor. Select an action from the drop down menu.

Open the expression task editor. Select an action from the drop down menu.

Expression Task - Step 2
To call a function, select ‘Call Function’. Click the ellipsis in the ‘Value/Expression’ field to create an expression.

To call a function, select ‘Call Function’. Click the ellipsis in the ‘Value/Expression’ field to create an expression.

Expression Task - Step 3
This will open the expression editor. Click on the ‘Function’ tab on the left side of the window to display all the functions that can be used in this task.

This will open the expression editor. Click on the ‘Function’ tab on the left side of the window to display all the functions that can be used in this task.

Expression Task - Step 4
Expand the Folder Operations node. Drag and drop the ‘DirCreate’ function into the expression window.

Expand the Folder Operations node. Drag and drop the ‘DirCreate’ function into the expression window.

Expression Task - Step 5
Add directory to be created.

Add directory to be created.

Expression Task - Step 6
Click the Validate button to check your expression.

Click the Validate button to check your expression.

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