Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Rowversion for Incremental Loads Expand / Collapse
Author
Message
Posted Monday, December 28, 2009 1:19 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, September 3, 2013 2:05 PM
Points: 15, Visits: 167
Hi,
row version in SSIA
Thanks
Kicki
Post #839568
Posted Monday, June 28, 2010 4:27 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 9:34 AM
Points: 42, Visits: 469
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
Post #944319
Posted Saturday, January 29, 2011 1:30 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, September 3, 2013 2:05 PM
Points: 15, Visits: 167
What Algorithim you are talking about...can you explain

Post #1055814
Posted Saturday, January 29, 2011 1:31 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, September 3, 2013 2:05 PM
Points: 15, Visits: 167
How you determine what number to subtract ...
Post #1055816
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse