All courses
Resource hub
Featured resource
Tech Upskilling Playbook 2025
Tech Upskilling Playbook

Build future-ready tech teams and hit key business milestones with seven proven plays from industry leaders.

Learn more
Hamburger Icon
  • Course
    • Libraries: If you want this course, consider one of these libraries.
    • Data

Advanced Integration Services - Part 2

This course teaches you how to develop, deploy, and secure Integration Services packages that manage specific types of data warehouse extract, transform, and load operations.

Get started

What you'll learn

This course explains how to apply Integration Services features to build packages that support the extract, transform, and load operations of a data warehouse. It shows strategies for managing high-volume, slowly changing dimensions and for handling text and XML files. It also explains how to adapt packages to work with Azure resources. In addition, this course reviews how to deploy packages to production and how to secure and execute deployed packages. This course was written for SQL Server 2014 Integration Services, but most principles apply to SQL Server 2005 and later.

Table of contents