Great place to learn JSF in a virtual world!... More Testimonials »

MOC 6235 - Implementing and Maintaining Microsoft SQL Server 2008 Integration Services

Delivery Options

Class Date and Time Price Pricing Information
Sep 15 - 17, 2010 10:00 AM - 6:00 PM ET $1,425.00 or 3 vouchers
Oct 13 - 15, 2010 10:00 AM - 6:00 PM ET $1,425.00 or 3 vouchers
Oct 27 - 29, 2010 10:00 AM - 6:00 PM ET $1,425.00 or 3 vouchers

Class Description

Class Overview

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

This SSAS 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.

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

  1. Introduction to SQL Server 2008 Integration Services
    1. Overview of SQL Server Integration Services
    2. Using Integration Services Tools
    3. Lab: Introduction to SQL Server Integration Services
  2. Developing Integration Services Solutions
    1. Creating an Integration Services Solution
    2. Using Variables
    3. Building and Running a Solution
    4. Lab: Developing Integration Services Solutions
  3. Implementing Control Flow
    1. Control Flow Tasks
    2. Control Flow Precedent Constraints
    3. Control Flow Containers
    4. Lab: Implementing Control Flow
  4. Implementing Data Flow
    1. Data Flow Sources and Destinations
    2. Basic Data Flow Transformations
    3. Advanced Data Flow Transformations
    4. Data Flow Paths
    5. Lab: Implementing Data Flow
  5. Implementing Logging
    1. Overview of Integration Services Logging
    2. Enabling and Configuring Logging
    3. Lab: Implementing Logging
  6. Debugging and Error Handling
    1. Debugging a Package
    2. Implementing Error Handling
    3. Lab: Debugging and Error Handling
  7. Implementing Checkpoints and Transactions
    1. Implementing Checkpoints
    2. Implementing Transactions
    3. Lab: Implementing Checkpoints and Transactions
  8. Configuring and Deploying Packages
    1. Package Configurations
    2. Deploying Packages
    3. Lab: Configuring and Deploying Packages
  9. Managing and Securing Packages
    1. Managing Packages
    2. Securing Packages
    3. Lab: Managing and Securing Packages

Class Materials

All students receive a course manual or book and all the class examples.

Students in private onsite classes will also receive:

Class Prerequisites

Experience in the following areas is required:

  • 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).

Technical Requirements

Our computer technical requirements and setup process is easy, with support just a click away.

Client Success
  1. Independent Survey
  2. Client List
  3. Testimonials
Join The Team
  1. Learn how you can become a Webucator Trainer
  2. Career Opportunities
Locations

Recent Blog Articles

Inner Join vs. Semi-join in Oracle

Posted on Aug 31, 2010 by Beth Anglo

Oracle database administrators use tools like the Oracle Enterprise Manager to seek ways to improve their system. If the tool identifies ...


SharePoint 2010 List To Silverlight

Posted on Aug 30, 2010 by Bruce

Check out this video demonstration of how to access a SharePoint list using Microsoft Silverlight. In this video I retrieve data using ...


Reporting Constraint Exceptions in Oracle

Posted on Aug 24, 2010 by Beth Anglo

While a statement executes in Oracle, the server checks whether it violates any constraints defined against the objects being accessed. ...


Create a simple report with SQL Server Reporting Services 2008

Posted on Aug 24, 2010 by Donna

Need to learn how to create a basic report in SQL Server Reporting Services 2008?  Reporting Services has changed dramatically since SQL ...


Formatting SQL Code for Readability

Posted on Aug 21, 2010 by Nat Dunn

In Webucator’s Introduction to SQL class, we get students using SQL Server, Oracle, MySQL and sometimes even Microsoft Access or ...

Learn the benefits of online training with Webucator

Watch a 3-minute video about Webucator's instructor-led online training.

Learn about Webucator's online training from the CEO

In depth video from our CEO on Webucator's instructor-led online training.

© Webucator, Inc. All rights reserved. | Toll Free: 877-932-8228 | UK: 0808-101-3484 | From outside the USA: 315-849-2724| Fax: 315-849-2723