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.

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



Buy Now Free Trial Download Compare Editions More Features

Task Factory Null Handler Transform

The Null Handler Transform allows the user to replace null or blank values from their source data with a user defined value (e.g. replace null with empty string or vice versa)

Feature Highlights

  • Three actions available to handle null or blanks values
    1. Convert NULL value to user defined value
    2. Convert blank value to NULL
    3. Convert blank value to user defined value
  • Output replaced data to the same column in the transform or to a new output column.
Null Handler Transform

Null Handler Transform- Step 1
The NULL Handler transform gives developers different options for converting blank or NULL values. It’s an easy to configure transform that can be used in the data flow of any SSIS package.

Drag and drop the TF NULL Handler into the data flow. Double click it to open the configuration editor. This will display a list of all input columns.


The NULL Handler transform gives developers different options for converting blank or NULL values. It’s an easy to configure transform that can be used in the data flow of any SSIS package.

Drag and drop the TF NULL Handler into the data flow. Double click it to open the configuration editor. This will display a list of all input columns.


Null Handler Transform- Step 2

Click the drop down menu next to a column. There are 3 different options here.

Click the drop down menu next to a column. There are 3 different options here.

Null Handler Transform- Step 3

Select the preferred action. 

Each action has its own ‘Output Action’.


Select the preferred action. 

Each action has its own ‘Output Action’.


Null Handler Transform- Step 4
Click ‘OK’ and then ‘OK’ again. 

Attach data viewers and then execute the package.

Click ‘OK’ and then ‘OK’ again. 

Attach data viewers and then execute the package.

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