MS2795 Designing an ETL Solution Architecture Using Microsoft SQL Server 2005 Integration Services

Module 1: Planning for ETL

In this module, Students will learn how to plan the way in which data will be transferred and staged in an ETL solution.

Lessons

Lab 1: Planning an ETL Solution

After completing this module, students will be able to:

Module 2: Planning an SSIS Solution

In this module, students will learn how to plan an SSIS-based ETL solution. Specifically, they will learn how to plan SSIS packages, how to plan an effective package development process, and how to design the control flow within the packages.

Lessons

Lab 2: Implementing SSIS Packages

After completing this module, students will be able to:

Module 3: Designing Data Flow

In this module, students will learn how to design data flows that extract, transform, and load data. They will also learn about factors to consider when working with slowly changing dimensions (SCDs) and when implementing custom SCD transformations.

Lessons

Lab 3: Implementing Data Flow

After completing this module, students will be able to:

Module 4: Logging, Error Handling, and Reliability

In this module, students will learn how to incorporate logging, error handling, and reliability into your SSIS package designs. The module covers standard logging, custom logging, and log reporting. The module also teaches students how to implement error handling and how to handle bad data. Finally, the module shows students how to implement a transaction strategy, use checkpoints, and handle restarts and rollbacks.

Lessons

Lab 4: Implementing Reliable Packages

After completing this module, students will be able to:

Module 5: Optimizing an SSIS Solution

In this module students will learn how to monitor and optimize SSIS performance. They will also learn how to scale-out SSIS packages

Lessons

Lab 5: Optimizing Packages

After completing this module, students will be able to:

Module 6: Deploying and Operating an SSIS Solution

This module describes considerations for deploying an SSIS solution into a production environment. It also discusses some of the issues related to operations and management that you must consider when planning an SSIS solution.

Lessons

Lab 6: Deploying and Managing Packages

After completing this module, students will be able to: