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.
Course info
Rating
(90)
Level
Intermediate
Updated
March 17, 2015
Duration
4h 44m
Table of contents
Security
37m 2s
Description
Course info
Rating
(90)
Level
Intermediate
Updated
March 17, 2015
Duration
4h 44m
Description

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.

About the author
About the author

Stacia Misner Varga is a consultant, instructor, author, mentor, BI Partner for SQLSkills, and principal of Data Inspirations specializing in Microsoft business intelligence technologies for over 10 years. She is a frequent speaker at the PASS Summit, IT/Dev Connections conferences, and various SQL Saturday and Microsoft-related events worldwide.

More from the author
Getting Started with Power BI
Beginner
3h 14m
23 Jun 2016
Building Blocks of Biml
Beginner
4h 10m
29 Dec 2015
More courses by Stacia Misner Varga