MS SSIS Microsoft SQL Server Integration Services Training

This two-day training is designed to help understand all aspects of SQL Server Integration Services (SSIS), the ETL tool of choice for SQL Server users. Through a variety of lab exercises and real-world examples, students will gain familiarity in how the design and execution environments work.

Retail Price: $1,195.00

Next Date: 11/19/2020

Course Days: 2


Enroll in Next Date

Request Custom Course


This two-day training is designed to help understand all aspects of SQL Server Integration Services (SSIS), the ETL tool of choice for SQL Server users.  Through a variety of lab exercises and real-world examples, students will gain familiarity in how the design and execution environments work.

Audience

The target audiences of this class are developers, architects or IT professionals who have basic SQL skills.

Prerequisites

In addition to their professional experience, students who attend this training should already have the following technical knowledge:

  • At least 2 years’ experience of working with relational databases
  • A solid understanding of SQL objects, to include tables, relationships, columns, data types, etc.
  • Some exposure to basic programming constructs (such as looping and branching).

Module 1: Creating an ETL Solution

At the end of this module you will be able to implement data flow in a SSIS package.

Lessons:

  • Introduction to ETL with SSIS
  • Exploring Source Data
  • Implementing Data Flow

Lab: Implementing Data Flow in an SSIS Package

After completing this module, you will be able to:

  • Describe ETL with SSIS
  • Explore Source Data
  • Implement a Data Flow

 Module 2: Implementing Control Flow in an SSIS Package

This module describes implementing control flow in an SSIS package.

Lessons:

  • Introduction to Control Flow
  • Creating Dynamic Packages
  • Using Containers

Lab: Implementing Control Flow in an SSIS Package

Lab: Using Transactions and Checkpoints

After completing this module, you will be able to:

  • Describe control flow
  • Create dynamic packages
  • Use containers

Module 3: Debugging and Troubleshooting SSIS Packages

This module describes how to debug and troubleshoot SSIS packages.

Lessons:

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

Lab: Debugging and Troubleshooting an SSIS Package

After completing this module, you will be able to:

  • Debug an SSIS package
  • Log SSIS package events
  • Handle errors in an SSIS package

 Module 4: Extending SQL Server Integration Services (SSIS)

This module describes how to extend SSIS with custom scripts and components.

Lessons:

  • Using Custom Components in SSIS
  • Using Scripting in SSIS

Lab: Using Scripts and Custom Components

After completing this module, you will be able to:

  • Use custom components in SSIS
  • Use scripting in SSIS

Module 5: Deploying and Configuring SSIS Packages

This module describes how to deploy and configure SSIS packages.

Lessons:

  • Overview of SSIS Deployment
  • Deploying SSIS Projects
  • Planning SSIS Package Execution

Lab: Deploying and Configuring SSIS Packages

After completing this module, you will be able to:

  • Describe an SSIS deployment
  • Deploy an SSIS package
  • Plan SSIS package execution
Course Dates Course Times (EST) Delivery Mode GTR
11/19/2020 - 11/20/2020 9:30 AM - 5:00 PM Virtual Enroll