Post reply

ISNULL question

  • May 9, 2022 at 7:05 am

    #4029323

    I am trying to use ISNULL in derived Column in SSIS. I have tried using this code

     

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

     

    It shows error message please correct

  • May 9, 2022 at 7:20 am

    #4029326

    Got it resolved

     

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

  • May 9, 2022 at 12:57 pm

    #4029432

    If this works, it's a bit simpler. Can't remember how SSIS handles NULL values in expressions like this, so might not work.

    replace(FirstName + " " +  MiddleName + " " +  LastName, "  ", " ")

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

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

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