Conversion

I want to convert the column value to 0 if the value is NULL or empty string in the derived column transformation (SSIS).
Please suggest.

isnull([column]) || [column] == "" ? 0 : [column]

Dunno about SSIS specifically, but "convert value to 0 if the value is NULL or empty string" can be done in SQL as:

IsNull(NullIf(MyColumn, ''), 0)

if there might be trailing spaces then:

IsNull(NullIf(RTrim(MyColumn), ''), 0)