Conditional Derived Column

Demonstrates the use of the derived column transformation to convert column values from null to a text value in SSIS 2005