Levi, Ray & Shoup, Inc.
  • Courses
  • Site Content

S2K20463-1 - Using SSIS with Microsoft SQL Server

In this one day course the Students will learn how to create implement ETL solutions with SQL Server Integration Services. It gives a comprehensive coverage including the following:
•Exploring Data Sources
•Implementing Data Flow
Introduction to Control Flow
•Creating Dynamic Packages
•Using Containers
•Managing Consistency
This course is intended for database professionals who need to develop SSIS packages for data extraction, transformation, and loading.

Click here to print this page »

Prerequisites


Before attending this course, students must have:
  • Exposure to enterprise data import and export scenarios.
  • Experience navigating the Microsoft Windows Server environment.
  • Experience with Microsoft SQL Server, including:
  • SQL Server Agent.
  • SQL Server query language (SELECT, UPDATE, INSERT, and DELETE).
  • SQL Server System tables.
  • SQL Server accounts (users and permissions).

Detailed Class Syllabus


Module 1: Creating an ETL Solution with SSIS


Introduction to ETL with SSIS
Exploring Data Sources
Implementing Data Flow

Module 2: Implementing Control Flow in an SSIS Package


Introduction to Control Flow
Creating Dynamic Packages
Using Containers
Managing Consistency

Module 3: Debugging and Troubleshooting SSIS Packages


Debugging an SSIS Package
Logging SSIS Package Events
Handling Errors in an SSIS Package