SQL Server Integration Services Tutorial - Pt. 1 - How to Perform Set-Based Incremental Updates (SQL Server to SQL Server)

SQL 2005 Integration Services Training: Pt. 1 - How to Perform Set-Based Incremental Updates (SQL Server to SQL Server)

One very common data movement scenario within SSIS is having a source table that you need to keep in sync with a destination table. This video, part 1, talks about the options available to you if you need to append rows from a source table to a target table, update only the changed rows with SSIS, or to delete rows at the destination that have also been deleted at the source.

Highlights from this video:

• How to know when to use Set-Based incremental deltas or cursor-style (a decision tree)
• Using the four part object identification to make addressing objects simpler

and much more

NOTE: Please watch the "Options Available for Performing Incremental Updates/Deltas with SSIS" video before watching this one.

This video is part of LearnItFirst's SQL Server 2005 Integration Services training course.

Related Links:

• Video detail page
• Course home page
• Free IT Training Videos
• Free SQL Server videos