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