SQL Server 2005 Integration Services Training: Introduction to SQL Server 2005 Integration Services (SSIS)

Course Number: SQL-124
GSA/Previous Course Number: 656
Duration: 3 days
view class outline

Looking for SSIS 2008 training?

SQL Server 2005 Integration Services Training Overview

Accelebrate's Introduction to SQL Server 2005 Integration Services training teaches attendees how to use SSIS to build high performance data integration solutions. SSIS training clients currently using DTS are encouraged to bring a package or two of reasonable size and complexity to class as a case study for porting a DTS package to SSIS.

Location and Pricing

Most Accelebrate courses are taught on-site at our clients' locations worldwide for groups of 3 or more attendees and are customized to their specific needs. Please visit our client list to see organizations for whom we have recently delivered training. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor's or students' travel expenses. To receive a customized proposal and price quote private training at your site or online, please contact us.

In addition, some courses are available as live, online classes for individuals. To see a schedule of online courses, please visit http://www.accelebrate.com/online_training/sql.htm.

SQL Server 2005 Integration Services Training Prerequisites

All SSIS training attendees should have prior experience working with SQL Server 2005.

Hands-on/Lecture Ratio

This SSIS training is 70% hands-on, 30% lecture, with the longest lecture segments lasting for 10 minutes.

SQL Server 2005 Integration Services Training Materials

All SSIS training students will receive a copy of McGraw-Hill's Hands-On SQL Server 2005 Integration Services and comprehensive courseware covering all topics taught.

Software Needed on Each Student PC

Windows 2000 Pro, XP Pro, Windows Server 2003, Windows Server 2008, Vista Business/Ultimate, or 7 with latest service packs applied
SQL Server 2005 full install, including Integration Services, with latest service packs applied
At least 1GB RAM (2GB recommended)
Sample databases and related tools - please contact us for a detailed setup sheet

SQL Server 2005 Integration Services Training Objectives

All attendees will learn to:

Use BIDS (Business Intelligence Development Studio)
Orchestrate control flow and data flow
Work with variables and configurations
Debug your flows and handle errors
Set up sophisticated logging
Extend SSIS through custom code
Deploy and manage SSIS packages

SQL Server 2005 Integration Services (SSIS) Training Outline

A Guided Tour of SSIS

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

Introduction to Control Flow

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

Introduction to Data Flows

Data Flow Overview
Data Flow Pipeline
Data Flow Sources
Data Flow Destinations
Data Viewers
Data Flow Transformations

Variables and Configurations

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

Advanced Control Flow

Advanced Control Flow Overview
Using Containers
Transactions Support in SSIS
Additional Control Flow Tasks

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
The SSIS scripting
Scripting in Control Flows
Scripting in Data Flows
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 Windows Event Log

Conclusion

VB.NET, C#, ASP, & ASP.NET Training

Java Training

SQL Server Training
SharePoint Training

“Accelebrate,” “Accelerated Learning Celebrated Results,” and the Accelebrate logo are registered trademarks of Accelebrate, Inc. All other product names and trademarks are property of their respective owners. Course outline content may mirror or be derived from the book that each student receives with the course. Otherwise, all content is copyright © 2003- by Accelebrate, Inc. of Atlanta, Georgia, USA. To contact us, please use the contact form, email info@accelebrate.com us, or call 1 877 849 1850 in the US and Canada, 0808 234 2132 in the UK, 1 800 550 311 in Ireland, or +1 678 648 3113 from all other locations.