CERTIFICATIONS

PROGRAMS

LEARN > Find a Class > Class Summary

MS6235 - Implement and Maintain SQL Server 2008 Integration Services

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 three-day instructor-led course teaches students how to implement an Integration Services (SSIS) solution in an organization. The course discusses how to develop, deploy, and manage Integration Services packages.

Click here for a printer-friendly version of this page

Upcoming classes

	Number	Class Date	Location	Length	Cost	Sign up
	MS6235	Mar 05, 2012 - Mar 07, 2012	Bloomington	3 days	$1395.00	Register

Prerequisites

Before attending this course, students must have:

Exposure to enterprise data import and export scenarios.

Experience navigating the Microsoft Windows Server environment.

Experience with Microsoft SQL Server, including:

SQL Server Agent.

SQL Server query language (SELECT, UPDATE, INSERT, and DELETE).

SQL Server System tables.

SQL Server accounts (users and permissions).

Detailed Class Syllabus

Module 1: Introduction to SQL Server 2008 Integration Services

Lesson 1: Overview of SQL Server Integration Services

Lesson 2: Using Integration Services Tools

Module 2: Developing Integration Services Solutions

Lesson 1: Creating an Integration Services Solution

Lesson 2: Using Variables

Lesson 3: Building and Running a Solution

Module 3: Implementing Control Flow

Lesson 1: Control Flow Tasks

Lesson 2: Control Flow Precedent Constraints

Lesson 3: Control Flow Containers

Module 4: Implementing Data Flow

Lesson 1: Data Flow Sources and Destinations

Lesson 2: Basic Data Flow Transformations

Lesson 3: Advanced Data Flow Transformations

Lesson 4: Data Flow Paths

Module 5: Implementing Logging

Lesson 1: Overview of Integration Services Logging

Lesson 2: Enabling and Configuring Logging

Module 6: Debugging and Error Handling

Lesson 1: Debugging a Package

Lesson 2: Implementing Error Handling

Module 7: Implementing Checkpoints and Transactions

Lesson 1: Implementing Checkpoints

Lesson 2: Implementing Transactions

Module 8: Configuring and Deploying Packages

Lesson 1: Package Configurations

Lesson 2: Deploying Packages

Module 9: Managing and Securing Packages

Lesson 1: Managing Packages

Lesson 2: Securing Packages