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.