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
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