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

SQL Server Training


Our instructor is very knowledgeable of the subject. I like that we are able to ask very specific questions at any time during the course and get a complete and accurate answer.
Comment from FacilicorpNB

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