Post reply

Derived column question with ISNULL

  • December 16, 2013 at 10:59 am

    #286161

    I have very simple requirement. I would have done this at the query level. Just wanted to learn how to do it in SSIS also

    CASE WHEN MiddleName IS NULL THEN FirstName + ' ' + LastName ELSE FirstName + ' ' + MiddleName + ' ' + LastName END AS FullName

    Just wanted to check how i can use ISNULL in derived column to build new column

  • December 16, 2013 at 11:07 am

    #1673813

    ISNULL( MiddleName)? FirstName + LastName:FirstName+MiddleName+LastName

    Got it

  • December 17, 2013 at 1:42 am

    #1673971

    You forgot to add a space delimiter between names 😉

    Raunak J

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply