SSIS 2008 Training Video: Incremental Updates: Options Available for Performing Incremental Updates with SSIS, Part 2

Incremental Updates: Options Available for Performing Incremental Updates with SSIS, Part 2 - view details
In the previous video Scott gave a brief overview of the different options available for performing incremental updates with SSIS. In this video Scott will cover the three main techniques for performing incremental loads with SSIS in depth, as well as how to actually accomplish an incremental load.

Highlights from this video:Status columnexample (I, U, D. or N)
writing a query that will show rows that need to be added
LastModified or ModifiedDatafilter for source rowsHow do you deal with deletes?
Change Data Capture (CDC)when using SQL 2008 as a sourcefilter on changes since last syncHow to accomplish an incremental loadseries of execute SQL tasksdata flow task with conditional split
and much more Source: http://www.learnitfirst.com/Course/158/Video/2161/Pt2-Options-For-Incremental-Updates.aspx Course: http://www.learnitfirst.com/Course/158/SSIS-2008.aspx Skill Level: 500 (Advanced) Length: 10:30 (31.7MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: SSIS 2008, incremental updates, incremental loads, options, status column, lastmodified, modifieddata, change data capture, CDC, execute sql task, data flow task, conditional split

This video comes from the SSIS 2008 online training course, SQL Server 2008 Integration Services. And be sure to check out even more SQL 2008 Integration Services training videos.