SQL Server Integration Services Tutorial Video - Options Availabl e for Performing Incremental Updates/Deltas with SSIS

SQL 2005 Integration Services Video: Options Available for Performing Incremental Updates/Deltas with SSIS

One very common data movement scenario within SSIS is having a source table that you need to keep in sync with a destination table. For example: you have a table in your mainframe database that is just huge - 200 million rows. Your company does not expose the mainframe database to the web; instead they've built a complex data movement package that copies the data out of the mainframe and into a SQL Server database that the website uses. Previously, they were able to delete the old rows and simply replace the SQL Server data with the mainframe data - but, with 200 million rows to copy over, this has become impossible. How can you help?

You have a few options - and this videos helps you learn what those options are and when to use each!

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 Windows Server training videos