Export (0) Print
Expand All

ISNULL (SSIS Expression)


Returns a Boolean result based on whether an expression is null.



Is a valid expression of any data type.

This example returns TRUE if the DiscontinuedDate column contains a null value.


This example returns "Unknown last name" if the value in the LastName column is null, otherwise it returns the value in LastName.

ISNULL(LastName)? "Unknown last name":LastName

This example always returns TRUE if the DaysToManufacture column is null, regardless of the value of the variable AddDays.

ISNULL(DaysToManufacture + @AddDays)
© 2015 Microsoft