Online Course: SQL Server Integration Services

SSIS (SQL Server Integration Services)

All 12 Sessions - On Demand
November 1st, 2010 through November 30th, 2010

Course Overview

As we build larger and more powerful data centric applications, the need to bring all this information together will become more and more important. Building efficient and intelligent ETL processes will be both a requirement and a skill that will be found to be in high demand. SQL Server Integration Services (SSIS) is one such ETL tool, and because it comes with Microsoft SQL Server, it will also continue to rise in popularity.

This Virtual Class, delivered by Microsoft SQL Server MVP Eric Johnson, will guide you into the world of SQL Server Integration Services. The class will start at the very basics of making a new package, and will progress towards advanced topics such as debugging and deployment. The entire goal of the course is to take you from never having used SSIS to being a competent SSIS developer in twelve sessions delivered over four weeks.

Course Structure/Cost

The course will be available on demand beginning November 1st. The 12 classes will be available on demand for 30 days only. Upon registration and payment you will receive an email with instructions on how to test your system in order to view the classes, as well as a link that will remain active for the 30 day on demand period. The course cost is $199, and the cost of the DVD with purchase of the course is an additional $199. The cost of the DVD without the purchase of the course is $399. Course downloads, office hours and the ability to email questions to the instructor are included with course purchase only. Once you have completed the course you will have the opportunity to take a course quiz and receive a course certificate. After passing the quiz, please allow 5 business days to receive the certificate (.pdf via email).



    Eric Johnson

    Eric is the co-founder of Consortio Services, and the primary Database Technologies Consultant.

    His background in Information Tec...


  • Session 1: The SSIS Basics

    In this opening session, we will look at the structure of the class and what to expect for the next twelve sessions. We begin our tour of SSIS by look...

  • Session 2: Control Flow Basics

    In Session 1, we overviewed the different components that make up SSIS packages. In this session, we will take a detailed look at Control Flow. The Co...

  • Session 3: Data Flow - Sources and Destinations

    The Data Flow task will do most of the heavy lifting in SSIS packages and will usually be far more complex and detailed then anything you will do in t...

  • Session 4: Data Flow - Transformations

    Now that you are familiar with how to retrieve and store data using data flows, we will look at manipulating data with transformations. In this first ...

  • Session 5: Advanced Transformations

    In this session we will continue our look at transformations. The transformations in the session are all a bit more complex than those in session 4. S...