What's New in SQL Server 2016 Integration Services

SQL Server 2016 Integration Services contains many new features. This course explores all these new features in greater detail than Books Online to help you start using them faster.
Course info
Rating
(21)
Level
Intermediate
Updated
May 26, 2017
Duration
3h 20m
Table of contents
Description
Course info
Rating
(21)
Level
Intermediate
Updated
May 26, 2017
Duration
3h 20m
Description

The SQL Server 2016 version of Integration Services includes many new features. In this course, What's New in SQL Server 2016 Integration Services, you'll explore all of those latest features in great detail. First, you'll learn how to use new control flow tasks and data flow components in Integration Services packages. Next, you'll discover how to configure Integration Services, set up packages to use SQL Server high availability and data encryption features, and to perform data integration with the Azure platform. Finally, you'll dive into learning about the new deployment and logging options. By the end of this course, you'll have a clear understanding of what's new in Integration Services and how to start using the features that matter most to you.

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
Transcript
Transcript

Hi everyone, my name is Stacia Varga and welcome to my course What’s New in SQL Server 2016 Integration Services.

I am a business intelligence consultant and instructor at Data Inspirations, a company I started back in 2006 to help people understand what their data is telling them.

There’s actually quite a lot of new things in this particular release – probably the most new things I’ve seen in Integration Services since it’s initial release in SQL Server 2005.

In this course, we are going to go down every nook and cranny to see what’s new, see how it works, and explore a few implications about these new features that might not be so obvious on the surface. So what IS new in this release?

  • Several features that affect package development.
  • Also in this release are features related to high availability and data encryption.
  • And we’ll look at what’s included in the Azure Feature Pack for SQL Server 2016.
  • And last, we’ll wrap up this course by exploring the features that help us deploy and manage packages.

You can watch this course from beginning to end, which I hope you do, or you can just dive in wherever you need to and learn exactly what you need about the features that matter most to you.