SSIS Tutorial - Derived Column Transformation - Handling NULLs

Another SSIS Tutorial brought to you by BeardedDev.

In this video we take a look at the Derived Column Transformation, probably one the most used Transformation tasks and one of the easiest to learn, in this task we go through replacing NULLs using SSIS expressions.

This SSIS Tutorial will teach you how to get started designing a simple Integration Services package and how to get started with the Derived Column Transformation, you will understand how to replace NULLs within your SSIS package using either conditional logic through an expression or the new REPLACENULL function.

[houstonvanhoy]

Brad: Thank you for the demonstration of the REPLACENULL function. I am familiar with the COALESCE function in SSMS queries, so I am mildly surprise that MSFT didn't bring that function name over to SSIS / SSDT. Perhaps that function name was spoken for, or could not be re-used. Please comment.

[Sandroider]

In one scenario from source data there were NULLs and "NULL" text values written in source data so I used expression group_type == "NULL" ? NULL(DT_WSTR, 50) : group_type to get all rows to real NULLs, is there better way to do this?