Intro to Business Intelligence Development

Session 2 – SQL Server Integration Services Part 1

Overview

Date: Wednesday, May 13, 2009

Time: 10:00am PT / 1:00pm ET

Duration: 90 minutes

Price: $149 USD

Training Format: Web Seminar

This session will cover the basics of the SSIS architecture and development environment. We will learn how to implement an ETL process using SSIS and discuss how to work with Slowly Changing Dimensions.

Outline

SSIS Usage Scenarios
Control Flow
Data Flow
Control flow tasks overview
Data sources and destinations
Transformations
Slowly Changing Dimensions

Audience

The target audience for this session is SQL Server developers and administrators interested in learning about SQL Server Integration Services.

Other sessions for this workshop:

Introduction to Dimensional Data Modeling (90 minutes)
SQL Server Integration Services Part 2 (90 minutes)
Introduction to Data Mining (90 minutes)