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

  • 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