How to convert blank into null in ssis

sql-server error-handling ssis

In DataFlow use DerivedColumn component.

Replace your column and in expression put this line of code

ColumnName == "" ? NULL(DT_WSTR,50) : ColumnName

It will make sure to return null if column is empty

sql-server error-handling ssis

You might also want to check the option to Keep Null values on both source and destination connection (if available)

sql-server error-handling ssis

Did you tried something like (under assumption datatype is of string/varchar) :

LEN(TRIM([ColumnName]))==0 ? NULL(DT_WSTR, 10) : [ColumnName]

CodeHunter