Post reply

REPLACE IN SSIS

  • October 15, 2013 at 8:01 am

    #299982

    Hi Please find my expression as below in Derived Column in SSIS , I have it for ISNULL then replacing it with empty String . Now i need to Replace if Animal == Cat then Replace it with Dog . Can some one help me in achieving this expression . Thanks in Advance

    ISNULL([Animal) ? "" :[Animal]

  • October 15, 2013 at 12:35 pm

    #1658653

    I think I can help - you need to have the first part as ISNULL(fieldtotest) == TRUE ? replacement_value : else_value

    I learned the hard way on this one as it seems that sometimes the ISNULL() as you have it works perfectly but frequently enough I have to 'finish the thought' or I get weird results.

    Hope this does the trick.

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

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