Derived column question with ISNULL

  • Smash125

    Hall of Fame

    Points: 3527

    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

  • Smash125

    Hall of Fame

    Points: 3527

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

    Got it

  • Raunak Jhawar

    SSCoach

    Points: 15701

    You forgot to add a space delimiter between names 😉

    Regards/Raunak
    Now a member of Linkedin

    Please visit the all new Performance Point Forum
    Please visit the all new Data Mining and Business Analytics Forum

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

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