SQL Server Integration Services (SSIS) Training for Business Intelligence

Duration: 4 days
Labs: Yes
Language: English
23 NASBA CPE Credits (live, in-class training only)
Level: Intermediate

In this SQL server integration services course, you gain the skills to improve business intelligence capabilities by automating complex migration tasks and auditing the success or failure of migration processes. In addition, you will learn to transform data among heterogeneous data sources — such as text files, Oracle, Access, XML (Extensible Markup Language), ODBC (Open Database Connectivity), and OLE DB (Object Linking and Embedding Database) — and effectively and securely manage data migration across various platforms.

In this SSIS training course, you’ll gain the skills to migrate and transform data with SSIS. You learn to solve data management problems by creating dynamic packages for migrating, processing, and reporting on data for business intelligence. Specifically, you learn to deploy packages to an SSIS server, assemble tasks to perform complex data migrations, and enhance package functionality with scripting.

SQL Server Integration Services (SSIS) Training for Business Intelligence Delivery Methods

In-Person
Online

SQL Server Integration Services Training Course Information

In this SSIS Training for Business Intelligence course, you will learn how to:

Solve data management problems by migrating and processing data.
Perform nonstandard imports and exports using the Script component.
Assemble tasks to perform complex data migrations.
ETL (Extract, Transform and Load) data.
Incrementally migrate data from SQL (Structured Query Language) Server data sources using CDC (Change Data Capture).
Deploy packages to an SSIS catalog.

SQL Server Integration Services Prerequisites

You should have familiarity with relational database management systems, programming concepts, and SQL language.

SSIS Training Course Outline

Module 1: Introduction to Integration Services

Defining SQL SSIS (Server Integration Services)
Exploring the need for migrating diverse data
The role of BI (Business Intelligence)

Module 2: SSIS Architecture and Tools

Managing heterogeneous data

ETL (Leveraging the Extract, Transform and Load) capabilities of SSIS
Running wizards for basic migrations
Creating packages for complex tasks
Explore other supported data sources, such as Hadoop and NoSQL (not only SQL)

Illustrating SSIS architecture

Distinguishing between data flow pipeline and package runtime
Executing packages on the client side or hosted in the SSIS service
Bulletproofing a package with package environments
Package restorability with checkpoint files

Simplifying deployments

Distinguishing between project and package deployment modes
Deploying packages to the SSISDB (SSIS Catalog Database)
Running packages from SQL Server
Leveraging package parameters

Module 3: Implementing Tasks and Containers

Utilizing basic SSIS objects

Configuring connection managers
Adding data flow tasks to packages
Reviewing progress with data viewers
Assembling tasks to perform complex data migrations
Migrating multiple files with FOREACH container

Operating system-level tasks

Copying, moving, and deleting files
Transferring files with the FTP (File Transfer Protocol) task
Communicating with external sources
Sending messages through mail

Processing XML

Iterating XML nodes
Writing XML files from databases

Module 4: Extending Capabilities with Scripting

Writing expressions

Making properties dynamic with variables
Utilizing expressions in loop iterations

Script Task

Extending functionality with the Script Task
Debugging, breakpoints, and watches

Module 5: Transforming with the Data Flow Task

Performing transforms on columns

Converting and calculating columns
Transforming with Character Map

Profiling, combining, and splitting data

Merge, Union, and Conditional Split
Multicasting and converting data

Manipulating row sets and BLOB data

Aggregate, sort, audit, and look up data
Importing and exporting BLOB data
Redirecting error rows

Performing database operations

Executing a SQL task
Bulk inserting data from text files

Module 6: Error Handling, Logging and Transactions

Organizing package workflow

Defining success, failure, completion, and expression precedence constraints
Handling events and event bubbling

Designing robust packages

Choosing log providers
Adapting solutions with package configurations
Auditing package execution results
Accessing package data with ADO.NET (ActiveX Data Object)

Select Commercial or Government Pricing

$3,140

4-day instructor-led training course
One-on-one after-course instructor coaching
After-course computing sandbox

Would you like to take this course as a team?

Mar 30 - Apr 2 9:00 AM - 4:30 PM EDT

Ottawa or Virtual
May 19 - 22 9:00 AM - 4:30 PM EDT

Ottawa or Virtual
Jun 15 - 18 9:00 AM - 4:30 PM EDT

Herndon, VA or Virtual
Aug 11 - 14 9:00 AM - 4:30 PM EDT

Herndon, VA or Virtual
Sep 1 - 4 9:00 AM - 4:30 PM EDT

Ottawa or Virtual
Nov 3 - 6 9:00 AM - 4:30 PM EST

Ottawa or Virtual
Dec 1 - 4 9:00 AM - 4:30 PM EST

Herndon, VA or Virtual
Feb 9 - 12 9:00 AM - 4:30 PM EST

Ottawa or Virtual

Scroll to view additional course dates

$2,792

4-day instructor-led training course
One-on-one after-course instructor coaching
After-course computing sandbox

Would you like to take this course as a team?

Mar 30 - Apr 2 9:00 AM - 4:30 PM EDT

Ottawa or Virtual
May 19 - 22 9:00 AM - 4:30 PM EDT

Ottawa or Virtual
Jun 15 - 18 9:00 AM - 4:30 PM EDT

Herndon, VA or Virtual
Aug 11 - 14 9:00 AM - 4:30 PM EDT

Herndon, VA or Virtual
Sep 1 - 4 9:00 AM - 4:30 PM EDT

Ottawa or Virtual
Nov 3 - 6 9:00 AM - 4:30 PM EST

Ottawa or Virtual
Dec 1 - 4 9:00 AM - 4:30 PM EST

Herndon, VA or Virtual
Feb 9 - 12 9:00 AM - 4:30 PM EST

Ottawa or Virtual

Scroll to view additional course dates

Speak with a Learning Consultant

Inquiring For

Myself

Team/Group

First Name*

Last Name*

Email*

Phone Number*

Company*

Job Title

I'm interested In

* Required Fields

Speak with a Learning Consultant

Fill out the form below or call 888-843-8733

Inquiring For

Myself

Team/Group

First Name*

Last Name*

Email*

Phone Number*

Company*

Job Title

I'm interested In

* Required Fields

Need Help Finding The Right Training Solution?

Our training advisors are here for you.

SSIS Training for Business Intelligence Course FAQs

This is an intermediate-level SQL training course. We recommend some knowledge of relational database management systems, programming concepts, and SQL language prior to taking this course.

Microsoft Integration Services is a platform for building enterprise-level data integration and data-transformation solutions. You use Integration Services to solve complex business problems by copying or downloading files, sending e-mail messages in response to events, updating data warehouses, cleaning, and mining data, and managing SQL Server objects and data. The packages can work alone or in concert with other packages to address complex business needs. Integration Services can extract and transform data from various sources, such as XML data files, flat files, and relational data sources, and then load the data into one or more destinations.

SQL Server developers, administrators and analysts who need to migrate and transform data among diverse platforms.

It is essential for organizations to securely manage data migration among a myriad of platforms to enhance their business intelligence capabilities. In this course, attendees learn to use SQL Server Integration Services to extract, transform, load, and integrate data from various sources. Typical participants include database developers and analysts who need to migrate data among diverse platforms. In addition, database administrators who need to manage Integration Services packages stored on SQL Server and database professionals working in mixed DBMS (Database Management System) environments such as Oracle, Access, and SQL Server will benefit from this course.

Most tasks in this course can be carried out without programming. However, you will learn to use programming to extend the capabilities of SSIS even if you have never programmed before. The course will give all the necessary information to complete the exercises.

SSIS is one of the components of Microsoft's Business Intelligence platform. The other two consist of Reporting Services and Analysis Services. SSIS allows you to migrate data for decision-support purposes. Once migrated, you can analyze data with Analysis Services, and reports can be built using Reporting Services.

SQL Server Integration Services (SSIS) Training for Business Intelligence

SQL Server Integration Services (SSIS) Training for Business Intelligence Delivery Methods

SQL Server Integration Services Training Course Information

SSIS Training Course Outline

Module 1: Introduction to Integration Services

Module 2: SSIS Architecture and Tools

Module 3: Implementing Tasks and Containers

Module 4: Extending Capabilities with Scripting

Module 5: Transforming with the Data Flow Task

Module 6: Error Handling, Logging and Transactions

Live Instructor $3,140

Live Instructor $2,792

SSIS Training for Business Intelligence Course FAQs

Is this course an SSIS tutorial for beginners?

What is the SSIS package?

Who will benefit from this course?

How much of this class is focused on scripting and/or programming?

What is the role of SSIS in Business Intelligence?

Related Courses