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.
What you'll learn
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.
Table of contents
- Version Check 0m
- 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
- 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
- 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
- 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
- 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
- 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
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.