Overview
This two-day course is one of the popular new Quick series of courses and has been designed with an emphasis on
lab work and demonstrations by the instructor with very short lectures preceding the demonstration and labs.
The course contains 30 labs. The intended delivery is a short lecture followed by a demonstration of the concept by
the instructor then the lab for the student to practice what they just saw demonstrated.
Before attending this course, students should have:
This course is intended for IT Professionals.
MODULE 8: SSIS PACKAGES, DEBUGGING AND DEPLOYING Lab 1: THE BUSINESS INTELLIGENCE STACK
At Course Completion
Prerequisites
Target Student
Course duration
2 Days
Course outline
MODULE 1: COURSE OVERVIEW
This module explains how the class will be structured and introduces course materials and additional administrative
information.
Lessons
Lab 1: COURSE OVERVIEW
MODULE 2: SQL SERVER INTEGRATION SERVICES ARCHITECTURE
In this module we will explore architecture and version changes of SQL Server Integration Services. We’ll then
cover the building blocks needed to understand packages and how they are created.
Lessons
Lab 1: SQL SERVER INTEGRATION SERVICES ARCHITECTURE
In this module we will learn about and utilize the tools available to assist with package creation.
Lessons
Lab 1: SQL SERVER INTEGRATION SERVICES TOOLS
After completing this module, students will be able to:
MODULE 4: SQL SERVER INTEGRATION SERVICES TASKS
SSIS tasks are the foundation of the Control Flow in SSIS. In this module we will walk through tasks and utilize
them.
Lessons
Lab 1: SQL SERVER INTEGRATION SERVICES TASKS
After completing this module, students will be able to:
MODULE 5: DATA FLOW
The Data Flow task is where the bulk of your data heavy lifting occurs in SSIS. In this module we’ll discuss
methods for optimizing sources and explain destination options.
Lessons
Lab 1: DATA FLOW
At one point or another, when utilizing SSIS packages, you will encounter the need for dynamic capabilities. This
module aims to give you an understanding of how expressions work, and how variables and parameters set up
expressions on your SSIS project.
Lessons
Lab 1: THE BUSINESS INTELLIGENCE STACK
After completing this module, students will be able to:
Containers are objects in SQL Server Integration Services that provide structure to packages and services to tasks. In
this module we will explain how to create and configure containers, and utilize them effectively.
Lessons
Lab 1: CONTAINERS
In this module we will explain precedence constraints and the functionality that they provide, then demonstrate their
use. We’ll also cover logging, events, and deploying while demonstrating how to use them efficiently.
Lessons
After completing this module, students will be able to: