InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 07:00:53 GMT20http://www.sqlservercentral.com/Forums/Topic839568-94-1.aspxHow you determine what number to subtract ...Sat, 29 Jan 2011 13:31:31 GMTkick_12309http://www.sqlservercentral.com/Forums/Topic839568-94-1.aspxWhat Algorithim you are talking about...can you explain Sat, 29 Jan 2011 13:30:12 GMTkick_12309http://www.sqlservercentral.com/Forums/Topic839568-94-1.aspxYou 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.[b]Timestamp/Rowversion[/b]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.[b]Hashbytes[/b]http://www.sqlservercentral.com/articles/Data+Warehousing/69679/[quote][b]kick_12309 (12/28/2009)[/b][hr]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[/quote]Mon, 28 Jun 2010 16:27:46 GMTLangston Montgomeryhttp://www.sqlservercentral.com/Forums/Topic839568-94-1.aspxHi, row version in SSIAThanks KickiMon, 28 Dec 2009 13:19:53 GMTkick_12309