SETC Training844-434-7382
 Find a Course: 
Programming TrainingMicrosoft TrainingMS Office TrainingServer TrainingManagement TrainingNetwork TrainingAbout UsContact Us

SQL Server Training

The Teacher was very talented. As English is my second language, the teacher was able to understand what I was trying to say and answer easily all my questions.
Comment from DND

1. Title

  • Maintaining and Transforming Data with SSIS (SSISCOMP, 3 days)
    View PDF

2. Course Pre-requisites

  • Previous relational database experience

3. Target Audience

  • IT Professionals who want to master the SSIS environment

4. Dates and Pricing

2 People for Guaranteed Live or Virtual Delivery $2,250.00 per person

5. Outline

Module 1: SSIS Overview

Topic 1: SQL Server Core Services

Topic 2: SSIS Architecture

Topic 3: The .NET Framework Runtime

Topic 4: About .NET Namespaces

Topic 5: Using BI Development Studio

Topic 6: Creating a SSIS Project

Topic 7: Debugging a SSIS Package

Module 2: SSIS Essentials

Topic 1: About the Integration Services Template

Topic 2: Understanding Data Sources and Data Source Views

Topic 3: About Packages and the Package Explorer

Topic 4: Creating Packages

Topic 5: About Control Flow and Data Flow

Topic 6: About Event Handlers

Module 3: SSIS Data Sources

Topic 1: The Need for a Data Connection

Topic 2: Establishing a Connection using a Provider

Topic 3: About SQL Server and Oracle Connections

Topic 4: Creating a Data Source

Topic 5: Using Data Source Views

Module 4: SSIS Control Flow

Topic 1: Creating a Package

Topic 2: About Package Templates

Topic 3: The Need for Data to Process Separation

Topic 4: Distinguishing between the Control Flow and the Data Flow

Topic 5: About the Control Flow Designer

Topic 6: Implementing Structure with Containers

Topic 7: Implementing Functionality with Tasks

Topic 8: Implementing Precedence with Precedence Constraints

Module 5: SSIS Data Flow

Topic 1: Understanding the Need for Data Flows

Topic 2: About the Data Flow Designer

Topic 3: Implementing Inputs with Data Sources

Topic 4: Implementing Outputs with Data Destinations

Topic 5: Modifying and Aggregating Data with Tranformations

Topic 6: Connecting Inputs and Outputs with Data Paths

Topic 7: Handling Errors

Topic 8: Implementing Event Handlers

Module 6: Common Tasks

Topic 1: Using SSIS to Import and Transform Data

Topic 2: Using SSIS to Export and Transform Data

Topic 3: Using SSIS to Transfer Data between Servers

Topic 4: Using SSIS to Load a Data Warehouse

Topic 5: Using SSIS to implement a Complex Business Process

Topic 6: Loading a Data Warehouse with SSIS

SETC Training on LinkedIn follow @CTESTraining Follow us on Facebook
  Programming Training
  Microsoft Training
  Network Training
  Management Training
  Server Training
  Microsoft Office Training
Site developed and authored by Jean-Marc Choquette