CODEWITHSUNDEEP
sql-serverssisetlderived-column
Luiz
Luiz

Reputation: 141

SISS - Check Null DerivedColumn

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.

enter image description here

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.

Upvotes: 2

Views: 112

Answers (1)

Hadi
Hadi

Reputation: 37313

You can use the following expression:

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

References

Upvotes: 1

Related Questions