CERTIFICATIONS

PROGRAMS

LEARN > Find a Class > Class Summary

LRS-SSIS - Microsoft SQL Server 2005 Integration Services (SSIS)

If you have any questions about registering for this class, please call (877) 832-0688 Ext. 1493 or email us at getsmart@LRS.com

This course is designed to provide students hands on experience in building and managing SSIS packages. It focuses on the Extract – Transform – Load (ETL) paradigm and emphasizes delivering cleansed data to applications and reports as well as converting DTS packages to SSIS.

Click here for a printer-friendly version of this page

Prerequisites

Detailed Class Syllabus

Prerequisites:
This course is intended for students who are SQL Database Administrators or Developers. Knowledge of Transact SQL language, Database Schemas and Data Transformation Services is required.

Chapter 1:

Introduction to SQL Server Integration Services (SSIS)

Chapter 2:

SSIS Import and Export Wizard

Chapter 3:

SSIS Workflow

Chapter 4:

SSIS Control Flow Containers

Chapter 5:

SSIS Control Flow Tasks

Chapter 6:

SSIS Administration

Chapter 7:
SSIS Packages

Chapter 8:

SSIS Advanced Features

Chapter 9:

SSIS Data Flow Components

Chapter 10:

SSIS Data Flow Transformations

Chapter 11:

Deploying SSIS Packages

Chapter 12:

Migrating DTS to SSIS

Chapter 13:

Troubleshooting and Performance Tuning