Publisher: Microsoft

Version: 2005/8
Length: 2 day s
Course-ID: SX685GRB

Course Overview

In this course you will learn how to create, design, manage and use Integration Services packages using a step by step development process. You will examine how to apply SSIS (SQL Server Integration Services) to data warehousing applications.

Target student

Business analysts and users, developers and administrators.

Prerequisites

Previous exposure to any database system or spreadsheet data is assumed.


Getting Started with Integration Services
  • Introduction
  • Building your first Package
Designing Packages
  • Extracting and Loading Data
  • Using Data Flow Transformations
  • Managing Control Flow
  • Scripting Tasks
  • Debugging Packages
  • Managing Package Execution
Managing Packages
  • Detecting and Handling Processing Errors
  • Securing and Deploying SSIS Packages
  • Optimising SSIS Packages
Applying SSIS to Data Warehousing
  • Data Warehouse Concepts
  • Populating Data Warehouse Structures
  • SSIS General Principals