Preferred method of contact:

SQL Server Integration Services for Business Intelligence



Course Number



4 Days

PDF Add to WishList

In this SQL integration training course, you gain the skills to improve business intelligence capabilities by automating complex migration tasks, auditing the success or failure of migration processes, transforming data among heterogeneous data sources — such as text files, Oracle, Access, XML, ODBC and OLE DB — and effectively and securely managing data migration across various platforms.

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
  • Extract, Transform, and Load (ETL) data
  • Incrementally migrate data from SQL Server data sources using Change Data Capture (CDC)
  • Deploy packages to an SSIS catalog

Important Course Information

Recommended Experience:

  • Familiarity with relational database management systems, programming concepts, and SQL language

Who Should Attend: 

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


  • This course uses Microsoft SQL Server 2016, running on Windows Server 2016
  • This course is applicable to those using earlier versions of SQL Server

Course Outline

  • Introduction to Integration Services
  • Defining SQL Server Integration Services (SSIS)
  • Exploring the need for migrating diverse data
  • The role of Business Intelligence (BI)
  • SSIS Architecture and Tools

Managing heterogeneous data

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

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 restartability with checkpoint files

Simplifying deployments

  • Distinguishing between project and package deployment modes
  • Deploying packages to the SSISDB
  • Running packages from SQL Server
  • Leveraging package parameters
  • 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 task
  • Communicating with external sources
  • Sending messages through mail

Processing XML

  • Iterating XML nodes
  • Writing XML files from databases
  • 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
  • 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
  • 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
Show complete outline
Show Less

Convenient Ways to Attend This Instructor-Led Course

Hassle-Free Enrollment: No advance payment required to reserve your seat.
Tuition due 30 days after you attend your course.

In the Classroom

Live, Online

Private Team Training

In the Classroom — OR — Live, Online

Tuition — Standard: $2990   Government: $2659

Jun 19 - 22 (4 Days)
9:00 AM - 4:30 PM EDT
Ottawa / Online (AnyWare) Ottawa / Online (AnyWare) Reserve Your Seat

Jul 10 - 13 (4 Days)
9:00 AM - 4:30 PM EDT
New York / Online (AnyWare) New York / Online (AnyWare) Reserve Your Seat

Aug 21 - 24 (4 Days)
9:00 AM - 4:30 PM EDT
Herndon, VA / Online (AnyWare) Herndon, VA / Online (AnyWare) Reserve Your Seat

Sep 11 - 14 (4 Days)
9:00 AM - 4:30 PM EDT
Ottawa / Online (AnyWare) Ottawa / Online (AnyWare) Reserve Your Seat

Oct 9 - 12 (4 Days)
9:00 AM - 4:30 PM EDT
New York / Online (AnyWare) New York / Online (AnyWare) Reserve Your Seat

Nov 6 - 9 (4 Days)
9:00 AM - 4:30 PM EST
Herndon, VA / Online (AnyWare) Herndon, VA / Online (AnyWare) Reserve Your Seat

Dec 18 - 21 (4 Days)
9:00 AM - 4:30 PM EST
Ottawa / Online (AnyWare) Ottawa / Online (AnyWare) Reserve Your Seat

Jan 8 - 11 (4 Days)
9:00 AM - 4:30 PM EST
New York / Online (AnyWare) New York / Online (AnyWare) Reserve Your Seat

Feb 19 - 22 (4 Days)
9:00 AM - 4:30 PM EST
Herndon, VA / Online (AnyWare) Herndon, VA / Online (AnyWare) Reserve Your Seat

Mar 19 - 22 (4 Days)
9:00 AM - 4:30 PM EDT
Ottawa / Online (AnyWare) Ottawa / Online (AnyWare) Reserve Your Seat

Show all dates
Show fewer dates

Guaranteed to Run

When you see the "Guaranteed to Run" icon next to a course event, you can rest assured that your course event — date, time, location — will run. Guaranteed.

Private Team Training

Enrolling at least 3 people in this course? Consider bringing this (or any course that can be custom designed) to your preferred location as a private team training.

For details, call 1-888-843-8733 or Click Here »

This event has been added to your cart.




In Classroom or





Private Team Training

Contact Us »

Course Tuition Includes:

After-Course Instructor Coaching
When you return to work, you are entitled to schedule a free coaching session with your instructor for help and guidance as you apply your new skills.

After-Course Computing Sandbox
You'll be given remote access to a preconfigured virtual machine for you to redo your hands-on exercises, develop/test new code, and experiment with the same software used in your course.

Free Course Exam
You can take your Learning Tree course exam on the last day of your course or online any time after class.


Training Hours

Standard Course Hours: 9:00 am – 4:30 pm
*Informal discussion with instructor about your projects or areas of special interest: 4:30 pm – 5:30 pm

Enhance Your Credentials with Professional Certification

Learning Tree's comprehensive training and exam preparation guarantees that you will gain the knowledge and confidence to achieve professional certification and advance your career.

Earn 23 Credits from NASBA

This course qualifies for 23 CPE credits from the National Association of State Boards of Accountancy CPE program. NOTE: Only live, in-class attendance qualifies for NASBA CPEs. Read more ...

“This is the fifth course I’ve taken via AnyWare, and I love it! Within a week back at work, I was given the complicated task of combining 35 files into one. Because of what I learned in the SSIS course, I had the know-how to successfully complete the task.”

- J. Romero, Applications Systems Analyst

Chat Now

Please Choose a Language

Canada - English

Canada - Français