SQL Server 2005 Integration Services Training

How To Take This Class:

Live Instructor-Led Online Class > View Schedule or Register
Onsite Group Training > Request Pricing

Instructor-Led Online Course Tuition:

$1,350.00

Course Duration:

3 Days

Course Description:

This SSIS 2005 Training course will enable technology professionals with little or no ETL experience and minimal exposure to SQL Server 2005 and Visual Studio 2005 to be comfortable and productive with the SSIS tools and technologies. In this course students will learn about the SQL Server Management Studio (SSMS) and building Database Maintenance Plans. Students will also be introduced to the Business Intelligence Development Studio (BIDS) and working with Control Flow and Data Flow. Students will also become familiar with SSIS package management and package deployment along with learning to write solid code using debugging, error handling and logging techniques.

Course Objectives:

Upon successful completion of this course, students will be able to:

Use the SQL Server Management Studio tool to build database maintenance plans.
Work with Business Intelligence Development Studio.
Work with Control Flow and Data Flow.
Create and deploy SSIS packages.
Debug and handle errors in code.
Use logging techniques.

Course Audience:

This course is designed for technology professionals with little or no ETL experience and minimal exposure to SQL Server 2005 and Visual Studio 2005 who desire a better understanding of SSIS tools and technologies.

Course Prerequisites:

This course assumes no prior knowledge of SQL Server Integration Services. This course does assume prior knowledge of SQL Server 2005 and basic use of SQL Server Management Studio. Other tools used in this course include Notepad, Microsoft Excel, and basic features of Windows.

Course Syllabus:

A Guided Tour of SSIS

Understanding SSIS
Exploring and Executing an SSIS Package in BIDS
Exploring and Executing a Package Outside BIDS

Introduction to Control Flow

Overview of Control Flow in SSIS
Control Flow Tasks
Workflow Tasks
Other SQL Server Operations Tasks
Precedence Constraints
Data Processing Tasks

Introduction to Data Flows

Data Flow Overview
Data Flow Pipeline
Data Flow Sources
Data Flow Destination
Data Viewers
Data Flow Transformations

Variables and Configurations

Understanding Variables
Using Variables in Control Flow
Using Variables in Data Flow
Understanding Property Expressions
Using Property Expressions
Understanding Configurations
Using Configurations
Using Variables and Configurations Between Packages

Advanced Control Flow

Synchronous Transformations
Asynchronous Transformations
Working with Error Outputs
Using Advanced Transformations

Package Deployment

Overview of Deploying Packages
Deployment Challenges
Create a Package Deployment Utility
The Package Installation Wizard
Deploy a Package to the File System
Deploy a Package to SQL Server
Redeploying Updated Packages

Package Management

Overview of Package Management
Managing Packages with DTUtil
Managing Packages with SQL Server Management Studio
Executing Packages
Scheduling Packages with SQL Server Agent
SSIS Security

Introduction to Scripting and Custom Components

Extending SSIS Capabilities Through Code
SSIS Scripting
Scripting in Control Flows
Scripting in Data Flows
Script Compilation
Custom SSIS Components

Best Practices

Best Practices for Using SSIS
Best Practices for Package Design
Data Flow Best Practices

Beyond ETL: Other Scenarios for SSIS

Using SSIS Beyond ETL
Migrating SQL Servers with SSIS
SQL Server Maintenance Plans
Working with Analysis Services
Folder and File Management
Working with the Windows Event Log