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 6:19 am

    #1703265

    Phil Parkin (4/4/2014)

    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).

    Absolutely Phil, hence I stated '..calculate and store...';-)

    Lempster