SSIS Introduction

Who Should Attend?

The course is designed for anyone new to using SSIS and what to learn from the beginning best practice and understand the available tools.

Learning Objectives

  • Understand the key concept of SSIS
  • Work with the main tools within the SSIS Architecture
  • Appreciate Data Flows
  • Understand ETL packages

Course Content

  • SSIS Introduction & Historical Overview
  • SSIS Architecture
  • Packages
  • Control Flow
  • Data Flow
  • Variables
  • Parameters
  • Error Handling & Logging
  • The SSIS Package Designer
  • SSIS Tasks
  • SSIS Task Objects
  • Looping & Sequence Tasks
  • Data Mining Query Tasks
  • Data Preparation Tasks
  • RDBMS Server Tasks
  • Workflow Tasks
  • SMO Administration Tasks
  • Understanding the Data Flow
  • Common Transformations
  • Typical Mainframe ETL with Data Scrubbing
  • Joining Data
  • Accessing Heterogeneous Data