Updating Your Data Integration Skills to Microsoft® SQL Server™ 2005 Integration Services

Description:
In this course you build high-performance data integration and workflow solutions by using Microsoft SQL Server 2005 Integration Services (SSIS) platform. This course is intended for database developers, database administrators, and business intelligence developers, who are experienced in Microsoft SQL Server. This course also helps prepare you for certification exam 70-445.

Objectives:
At the end of the course, students will be able to:
Understand the features and the core concepts of the SSIS architecture.
Design SSIS packages by using Business Intelligence (BI) Development Studio.
Understand the features of SSIS that help in building high-performance data integration and workflow solutions.
Understand the features that extend the functionality of SSIS.

Modules & Lessons
Course Overview
Module Introduction
How to Use This Course
Course Information

Exploring SSIS Architecture and Core Concepts
Module Introduction

SSIS Architecture
Lesson Introduction
An Overview of SSIS
The Evolution from DTS to SSIS
The SSIS Development Environment
The SSIS Runtime
Self Test

SSIS Core Concepts
Lesson Introduction
Containers, Tasks, and Precedence Constraints
Data Flow Tasks
Connectivity
Variables and Package Configurations
Event Handlers and Log Providers
Self Test
Module Summary

Designing and Debugging SSIS Packages
Module Introduction

Creating Package Control Flow
Lesson Introduction
The SSIS Package Designer
An Overview of Control Flow
Adding and Configuring Containers
Adding and Configuring Tasks
Using Precedence Constraints
Self Test

Creating Package Data Flow
Lesson Introduction
An Overview of Data Flow
Adding Data Sources
Adding Transformations
Adding Destinations
Connecting Data Flow Components
Self Test

Designing for Scalability and Performance
Lesson Introduction
The OVAL Design Strategy
Operations and Volume
Application and Location
Performance Monitoring of SSIS Packages
Self Test

Debugging SSIS Packages
Lesson Introduction
Executing a Package
Setting Breakpoints
Adding a Data Viewer
Monitoring Data Flow Progress
Self Test

Lab: Creating and Debugging a Package
Lesson Introduction
Scenario
Exercises
Lab Review
Module Summary

Rich Functionality in SSIS
Module Introduction

Configuring and Deploying SSIS Packages
Lesson Introduction
An Overview of Package Deployment
Creating Package Configurations
Deploying a Package
Self Test

Enhancing ETL Operations
Lesson Introduction
Adding Logging to a Package
Parallel Operations
Sequence Containers
Lookup Caching
Using Checkpoints to Restart After Failure
Self Test

Working with Transformations
Lesson Introduction
Derived Column Transformation
Slowly Changing Dimension Transformation
Fuzzy Lookup Transformation
Fuzzy Grouping Transformation
Data Mining Query Transformation
Self Test

Lab: Configuring and Deploying a Package
Lesson Introduction
Scenario
Exercises
Lab Review
Module Summary

Extensibility
Module Introduction

Programmability
Lesson Introduction
Programming SSIS Tasks and Packages
Using the Script Task
Using the Script Component Transformation
Self Test

Beyond ETL
Lesson Introduction
Non-Traditional Data Sources
Alternative Transformations
Self Test

Lab: Transforming an RSS Feed
Lesson Introduction
Scenario
Exercises
Lab Review
Module Summary