Post reply

compare case sensitive and case in-sensitive values in Lookup transformation

  • August 20, 2012 at 2:09 am

    #265482

    I have Source and Dest tables

    table :source Table : Dest

    ----------------------------------------

    Col Col

    ----------------------------------------

    AA aa

    Bab BAb

    by default SSIS is Case Sensitive and my Database settings are Case in-sensitive

    When i Do a lookup on Col

    in this case, lookpup in SSIS treating both values 'AA' and 'aa' as same ....

    but i have to treat it as different values, which we can visually see it ...how should i achieve this ?

    I can achieve this by "Binary_CheckSum",but many blogs says that not 100% assured...

    MSDN : "BINARY_CHECKSUM(*) will return a different value for most, but not all, changes to the row, and can be used to detect most row modifications."

  • August 20, 2012 at 4:11 am

    This was removed by the editor as SPAM

  • August 20, 2012 at 4:38 am

    #1527499

    Thank You Very much.......:-)

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

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