What's New in SQL Server 2016 Integration Services
Pluralsight
Course Summary
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 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.
-
+
Course Syllabus
Course Overview- 1m 44s
—Course Overview 1m 44sExploring Options for the Package Development Workflow- 41m 18s
—Introduction 0m 47s
—Version Targeting 1m 31s
—Demo: Version Targeting 6m 5s
—Control Flow Package Parts 3m 20s
—Demo: Preparing to Implement Control Flow Package Parts 3m 6s
—Demo: Creating a Single-task Control Flow Package Part 4m 6s
—Demo: Handling Variables, Parameters, and Package Parts 3m 9s
—Demo: Configuring and Testing a Package Part 2m 9s
—Demo: Working with Multiple Tasks in a Package Part 3m 11s
—Demo: Using Package Parts from Another Project and Handling Changes 7m 11s
—Demo: Deploying Packages with Control Flow Package Parts 5m 55s
—Summary 0m 41sExploring New and Updated Control Flow Components- 39m 14sUsing New Data Flow Components- 35m 16sUnderstanding High Availability and Data Encryption in Integration Services- 21m 4sUsing Integration Services with Azure- 36m 14sManaging and Deploying Packages- 25m 15s