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.

Instructor did a great job, from experience this subject can be a bit dry to teach but he was able to keep it very engaging and made it much easier to focus. Student
Excellent presentation skills, subject matter knowledge, and command of the environment. Student
Instructor was outstanding. Knowledgeable, presented well, and class timing was perfect. Student

Click here to print this page »


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