Check this old thread :
You can add a "Derived Column" transformation. This allows you to replace null values with a default value. For instance, if you want to replace null values with a specific string, you can use an expression like:
iif(isNull(columnName), 'defaultValue', columnName)