MS203: Implementing and Maintaining SSIS

MS203: Implementing and Maintaining SQL Server Integration Services

 

Class Overview

 

In this SQL Server Integration Services (SSIS) training class, students learn how to implement an Integration Services solution in an organization. The course discusses how to develop, deploy, and manage Integration Services packages.

This SSIS class targets information technology (IT) professionals and developers who need to implement data transfer or extract, transform, and load (ETL) solutions by using Microsoft SQL Server 2008 Integration Services.

Duration: 24 Hours

Class Goals

Learn to describe SQL Server Integration Services and its tools.

Learn to create an Integration Services package.

Learn to implement control flow in an Integration Services package.

Learn to implement data flow in an Integration Services package.

Learn to implement logging in an Integration Services package.

Learn to debug and implement error handling in an Integration Services package.

Learn to implement checkpoints and transactions in an Integration Services package.

Learn to deploy an Integration Services package.

Learn to manage and secure an Integration Services package.

 

Class Outline

Introduction to SQL Server 2008 Integration Services

Overview of SQL Server Integration Services

Using Integration Services Tools

Lab: Introduction to SQL Server Integration Services

Developing Integration Services Solutions

Creating an Integration Services Solution

Using Variables

Building and Running a Solution

Lab: Developing Integration Services Solutions

Implementing Control Flow

Control Flow Tasks

Control Flow Precedent Constraints

Control Flow Containers

Lab: Implementing Control Flow

Implementing Data Flow

Data Flow Sources and Destinations

Basic Data Flow Transformations

Advanced Data Flow Transformations

Data Flow Paths

Lab: Implementing Data Flow

Implementing Logging

Overview of Integration Services Logging

Enabling and Configuring Logging

Lab: Implementing Logging

Debugging and Error Handling

Debugging a Package

Implementing Error Handling

Lab: Debugging and Error Handling

Implementing Checkpoints and Transactions

Implementing Checkpoints

Implementing Transactions

Lab: Implementing Checkpoints and Transactions

Configuring and Deploying Packages

Package Configurations

Deploying Packages

Lab: Configuring and Deploying Packages

Managing and Securing Packages

Managing Packages

Securing Packages

Lab: Managing and Securing Packages