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:12 am

    #1703261

    Koen Verbeeck (4/4/2014)

    You can also implement a hash yourself using a script component:

    Using hash values in SSIS to determine when to insert or update rows[/url]

    Yes and that would be my preferred way of doing it because you can use reduce the chance of hash collisions by using a stronger hash such as SHA1....but...the OP specifically stated that they didn't want to go down the scripting route. 😉

    Thanks for the link btw - I thought I had that saved to my favourites, but obviously not.