Home Forums Data Warehousing Integration Services Checking other 5 other columns for change and if they have set field null RE: Checking other 5 other columns for change and if they have set field null

  • April 4, 2014 at 4:01 am

    #1703229

    Lempster (4/4/2014)

    You could also use a 3rd party custom component such as the Checksum component from Konesans to calculate and store a checksum for the five address columns you are interested in and then compare the checksum of the source columns to the checksum of the destination columns; if the checksum values are different then at least one of your source columns has changed.

    Disclaimer: I am not connected to Konesans in any way.

    Regards

    Lempster

    This is a good solution. For good performance, you should consider persisting the checksum as a new column in the target table(s).

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.