Post reply

Rowversion for Incremental Loads

  • December 28, 2009 at 1:19 pm

    #156535

    Hi,

    row version in SSIA

    Thanks

    Kicki

  • June 28, 2010 at 4:27 pm

    #1186106

    You can certainly use the RowVersion column for incremental loads, if you have it on the source, and you should not really need anything else. Although, I would recommend using some sort of hashbyte algorithm as well to be thorough. I provided some links below to get you started. Hope they help.

    Timestamp/Rowversion

    http://www.sqlservercentral.com/articles/Video/65070/

    Tip: When using Timestamp/Rowversion, for good measure, I always like to subtract some set number from the max rowversion to ensure I pick up any updates missed due to lag.

    Hashbytes

    http://www.sqlservercentral.com/articles/Data+Warehousing/69679/

    kick_12309 (12/28/2009)

    Hi,

    I want to use rowversion for incremental loads in SSIS. Can I use rowversions alone or do need

    some other fields....how can I save the last rowversion value in table and how I query the table for

    next loads.

    Thanks

    Kicki

  • January 29, 2011 at 1:30 pm

    #1280120

    What Algorithim you are talking about...can you explain

  • January 29, 2011 at 1:31 pm

    #1280122

    How you determine what number to subtract ...

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

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