Advanced Integration Services - Part 2

Introduction 2m 8s T-SQL MERGE Statement: Type 1 SCD 4m 32s T-SQL MERGE Statement: Type 2 SCD 3m 34s Dimension Load Pattern with MERGE 1m 53s Demo: Slowly Changing Dimension Handling with MERGE 10m 34s Change Data Capture (CDC) 3m 56s CDC in Integration Services 8m 25s Demo: Slowly Changing Dimension Handling with CDC 14m 10s Custom Component 0m 56s Summary 1m 18s

Introduction 1m 0s Architecture Options 0m 43s Virtual Machines and SQL Databases 3m 35s Demo: Creating an Azure Virtual Machine 3m 7s Demo: Creating a SQL Database 3m 14s Hybrid: On-premises and Azure 0m 46s Demo: Creating a Virtual Network 7m 58s Demo: Joining an Azure Virtual Machine to an On-Premises Network 2m 11s ETL Strategies 1m 0s Data Connections 0m 28s Demo: Working with Data Connections in the Cloud 5m 25s ETL Design Patterns for the Cloud 2m 13s Demo: Modifying the ETL Design Pattern for the Cloud 11m 26s Data Subsets 1m 6s Demo: Extracting a Subset of Data 4m 59s File Compression 1m 20s Demo: Compressing Files for ETL 6m 30s Additional Considerations for Cloud Integration 0m 34s Planning for Failure 1m 30s Demo: Implementing Retry Logic 12m 2s Sharding 1m 19s Scaling Processes 2m 36s Summary 3m 10s

Introduction 1m 43s Deployment Target Options 2m 36s Deployment Utility 2m 56s Demo: Preparing for Deployment 1m 4s Demo: Package Installation Wizard Deployment to MSDB 1m 10s Demo: Package Installation Wizard Deployment to File System 2m 33s Other Deployment Tools 0m 52s Demo: Import into MSDB 1m 32s Demo: Use DTUTIL to Import into MSDB from File System in Bulk 1m 55s Package Configuration 3m 51s Demo: Working with Configurations 4m 57s Package Execution 1m 12s Execute Package Utility 1m 27s Demo: Using the Execute Package Utility 3m 10s DTExec Utility 1m 20s Demo: Using the DTEXEC Utility 1m 8s SQL Server Management Studio 0m 35s Demo: Running a Package in Management Studio 1m 2s SQL Server Agent Job 0m 23s Demo: Scheduling a Package as a SQL Server Agent Job 1m 16s Summary 1m 39s

Introduction 1m 7s SSIS Catalog 2m 11s Demo: Creating the SSIS Catalog 3m 6s Deployment Options Overview 0m 47s SSDT + Wizard Deployment 0m 40s Demo: Deploying a Project from SSDT 2m 0s ISPAC + Wizard Deployment 1m 19s Demo: Deploying a Project from an ISPAC File 2m 4s ISPAC + T-SQL Deployment 0m 32s Demo: Using T-SQL to Deploy a Project from an ISPAC File 1m 46s Demo: Restoring a Prior Project Version 1m 17s Environments 2m 14s Demo: Configuring Environments 1m 59s Package Execution Overview 0m 43s Package Execution with User Interface 0m 44s Demo: Executing a Package with a User Interface 6m 54s Package Execution with T-SQL 1m 37s Demo: Executing a Package with T-SQL 3m 7s Package Execution with DTExec 1m 55s Demo: Executing a Package with DTExec 1m 10s Package Execution with SQL Server Agent 0m 29s Demo: Creating a SQL Server Agent Job for Package Execution 1m 26s Data Taps in Package Execution 1m 27s Demo: Working with Data Taps 2m 32s Summary 1m 47s

Introduction 1m 10s Package Security Settings 1m 36s Package Protection Level: DontSaveSensitive 0m 33s Demo: Configuring and Testing DontSaveSensitive 2m 2s Package Protection Level: EncryptSensitiveWithUserKey 1m 4s Demo: Configuring and Testing EncryptSensitiveWithUserKey 1m 39s Package Protection Level: EncryptSensitiveWithPassword 0m 45s Package Protection Level: EncryptAllWithPassword 0m 45s Demo: Configuring and Testing EncryptAllWithPassword 1m 37s Package Protection Level: EncryptAllWithUserKey 0m 44s Package Protection Level: ServerStorage 1m 13s Digital Signature 0m 48s Demo: Signing and Verifying a Package in Visual Studio 1m 43s Demo: Verifying a Package in DTEXECUI 0m 55s Demo: Configuring the Registry to Verify Signatures 1m 24s Security for Package Deployment Model 1m 17s Demo:Configuring Server Storage for the Package Deployment Model 3m 14s Security for Project Deployment Model 3m 0s Demo: Configuring Server Storage for the Project Deployment Model 6m 12s Security for Scheduled Packages 1m 10s Demo: Configuring a Proxy Account for Scheduled Package Execution 1m 58s Summary 2m 2s

Introduction 0m 39s Working with Headers and Footers in Text Files 0m 43s Adding Header and Footer Rows: No Data in Header 2m 10s Demo: Adding Header and Footer Rows with No Data in Header 4m 22s Adding Header and Footer Rows: Data in Header 1m 13s Demo: Adding Header and Footer Rows with Data in Header 1m 52s Eliminating Header and Footer Rows 2m 32s Demo: Eliminating Header and Footer Rows 3m 52s XML Processing 1m 1s Importing XML Data 2m 16s Demo: Importing XML Data 2m 57s Validating XML Data 1m 7s Demo: Validating XML Data 1m 29s Transforming XML Data 2m 0s Demo: Transforming XML Data 2m 45s Summary 2m 42s