Ssis derived column expression is not null

The purpose of the function is pretty straightforward: check if a value is NULL and if it is, replace it with another value. The syntax is as follows:. So if expression1 is NULL, it will be replaced by expression2 by the derived column transformation.

If it is not NULL, expression1 itself is returned. If the data types of both arguments are different, SSIS will try to convert the data type of the 2nd expression to that of the 1st expression.

If the data types are incompatible, an error will be returned. Note that SSIS does not stop us from creating an expression with incompatible data types. Contents Exit focus mode. Please rate your experience Yes No. Any additional feedback? Thx — Hadi. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses.

Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Learn more. Asked 8 years, 6 months ago. Active 8 years, 6 months ago. Viewed 21k times. I need assistance writing an Derived Column expression that meets this criteria. Improve this question. Elaine Casey Elaine Casey 19 1 1 gold badge 1 1 silver badge 2 2 bronze badges.