Expanded

What's New in SQL Server 2016 Integration Services

By Stacia Misner Varga
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.
Get started
Play course overview
Course info
Rating
(35)
Level
Intermediate
Updated
May 26, 2017
Duration
3h 19m
Table of contents
Course Overview
Course Overview 2m
Exploring Options for the Package Development Workflow
Introduction 1m Version Targeting 2m Demo: Version Targeting 6m Control Flow Package Parts 3m Demo: Preparing to Implement Control Flow Package Parts 3m Demo: Creating a Single-task Control Flow Package Part 4m Demo: Handling Variables, Parameters, and Package Parts 3m Demo: Configuring and Testing a Package Part 2m Demo: Working with Multiple Tasks in a Package Part 3m Demo: Using Package Parts from Another Project and Handling Changes 7m Demo: Deploying Packages with Control Flow Package Parts 6m Summary 1m
Exploring New and Updated Control Flow Components
Introduction 1m Updated Excel Connection Manager 3m Updated Analysis Services Components 1m Demo: Reviewing Tabular Model Partitioning Concepts 4m Demo: Configuring Dynamic Tabular Partitioning Processing 4m Demo: Configuring the Partition Processing Destination 3m Updated XML Task 5m Hadoop Control Flow Components 1m Demo: Preparing Data for HDFS and Configuring the HDFS Task 5m Demo: Configuring Hive Tasks 3m Demo: Configuring Pig Tasks 3m Demo: Configuring the Hadoop Connection Manager 1m Demo: Executing a Package with Hadoop Control Flow Components 4m Summary 1m
Using New Data Flow Components
Introduction 1m Add-in Connectors Introduction and Demo 5m HDFS Data Flow Components Introduction and Demo 4m OData Support Introduction and Demo 5m Data Feed Publishing Introduction and Demo 6m Balanced Data Distributor Performance Analysis Demo 6m Buffer Sizing 1m Demo: Prepare for Buffer Sizing Testing 1m Demo: Buffer Size Tuning and Performance Analysis 6m Summary 1m
Understanding High Availability and Data Encryption in Integration Services
Introduction 1m Always on Availability Groups and SSIS 2m Demo: Preparing Databases for an Availability Group 1m Demo: Configuring Databases & SSISDB for an Availability Group 2m Demo: Reviewing SSISDB Failover 5m Always Encrypted 2m Demo: Setting up an Always Encrypted Table 1m Demo: Loading Data into an Encrypted Column 2m Demo: Using Parameterized Execute SQL Task with Always Encryptd Table 3m Demo: Extracting Data from an Encrypted Column 2m Summary 1m
Using Integration Services with Azure
Introduction 1m Integration Services Feature Pack for Azure 1m Demo: Azure Storage Connection Manager 3m Azure Subscription Connection Manager 1m Demo: Azure Resource Manager Connection Manager 2m Demo: Azure HDInsight Connection Manager 1m Demo: Azure Data Lake Connection Manager 1m Demo: Azure Blob Upload Task 3m SQL DW Upload Task 1m Demo: Creating a SQL DW 2m Demo: Using the SQL DW Upload Task 6m HDInsight Cluster Tasks & Big Data Processing in Azure 1m Demo: HDInsight Cluster, Hive, and Pig Tasks 6m Demo: Executing and Troubleshooting HDInsight Tasks 4m Azure Data Flow Processing 1m Demo: Azure Data Lake 2m Summary 1m
Managing and Deploying Packages
Introduction 1m Data Flow Diagnostics 1m Demo: Data Flow Diagnostics in SSDT 2m Demo: Data Flow Diagnostics in SSMS 3m Incremental Deployment 2m Demo: Incremental Deployment Workflow 3m Demo: Incremental Deployment Options 3m Package Logging 1m Demo: Runtime Lineage and Custom Log Levels 4m Demo: DiagnosticEx and Other Logging Results 2m Demo: Managing Log Security 2m Summary 1m
Description
Course info
Rating
(35)
Level
Intermediate
Updated
May 26, 2017
Duration
3h 19m
Your 10-day individual free trial includes:

Expanded library

This course and over 7,000+ additional courses from our full course library.

Hands-on library

Practice and apply knowledge faster in real-world scenarios with projects and interactive courses.
*Available on Premium only
Start a Premium 10-day free trial
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
Stacia Misner Varga
About the author

Stacia Misner Varga is an instructor, author, and principal consultant of Data Inspirations. Her career spans more than 30 years, with a focus on improving business practices through technology. Since 2000, she has provided consulting and education services for Microsoft’s data platform and authored or co-authored many books covering this topic. In addition, Stacia has been a frequent speaker over the years at technology conferences worldwide.

More from the author
Getting Started with Power BI
Beginner
4h 56m
Sep 3, 2021
Modeling Data in Power BI
Beginner
4h 56m
May 12, 2021
Building Your First Power BI Report
Beginner
1h 31m
Mar 1, 2021
More courses by Stacia Misner Varga
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi. I'm Stacia Varga, and welcome to my course, What's New in SQL Server 2016 Integration Services? I'm 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 that I've seen in integration services since it first was released in SQL Server 2005, so in this course we're 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? Well, there's several features that affect package development, features that are supposed to make it easier for you to build your packages more efficiently and faster. Also in this release, support has been added for high availability and data encryption features that exist in SQL Server 2016, and we'll look at what's included in the Azure Feature Pack for SQL Server 2016. Then last, we'll wrap up this course by exploring the features that help us deploy and manage packages, things like performing incremental deployments, and new ways to capture logging information about package execution. Now 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.

You're the smartest person in the room

PROVE IT

Your team won't just close the skills gap

THEY'LL HURDLE IT

Course info
Rating
(35)
Level
Intermediate
Updated
May 26, 2017
Duration
3h 19m
Pluralsight IQ
Know exactly where everyone on your team stands with assessments and analytics.
Try our full library including this course free for your whole team for 14-days.