Rowversion for Incremental Loads

• kick_12309

  Mr or Mrs. 500

  Points: 545

  More actions

  December 28, 2009 at 1:19 pm

  #156535

  Hi,

  row version in SSIA

  Thanks

  Kicki

• Langston Montgomery

  SSC Eights!

  Points: 934

  More actions

  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

• kick_12309

  Mr or Mrs. 500

  Points: 545

  More actions

  January 29, 2011 at 1:30 pm

  #1280120

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

• kick_12309

  Mr or Mrs. 500

  Points: 545

  More actions

  January 29, 2011 at 1:31 pm

  #1280122

  How you determine what number to subtract ...