TechNet Webcast: 24 Hours of SQL Server 2008: Streamlining Data Integration (Level 200)

Overview

To load data into the Contoso enterprise data warehouse, Contoso uses Microsoft SQL Server 2008 Integration Services. This webcast reviews the new features in Integration Services that help Contoso streamline the development and execution of processes to extract, transform, and load data into the data warehouse: ADO.NET connectivity, persistent lookups, pipeline improvements, and data profiling. It also examines alternatives for managing changing data in the data warehouse using the Change Data Capture function and MERGE command. Demonstrations on using an ADO.NET data source, working with lookup caches, identifying dirty data with data profiling, and using Change Data Capture and MERGE for slowly changing dimensions are included in this webcast.