SISS - Check Null DerivedColumn

Question

Does someone knows how to check IS Null expression on SISS ?

IF columns is NULL > RETURN NULL , IF is NOT return value from column

I am developing this on DerivedColumn.

FYI: The column is not always in my Excel layout, that is the reason that I have to check if that column exists or not.

Answer 1

You can use the following expression:

(ISNULL([InputColumn]) || [InputColumn] == "") ? NULL(DT_STR,50,1252) : [InputColumn]

References

• ? : (Conditional) (SSIS Expression)
• ISNULL (SSIS Expression)