Autoplay
Autocomplete
HTML5
Flash
Player
Speed
Previous Lecture
Complete and continue
SQL Server Integration Services for Developers and DBAs
Module 0: Getting started
Who is this course for? (0:39)
Who is Greg? (0:55)
What will I learn in this course? (0:59)
Configuring your lab environment (12:24)
Module 1: Overview of SSIS
What is SSIS? (2:06)
Typical role for SSIS (1:44)
Common sources of data (1:08)
Common integration challenges (3:01)
Tooling for building SSIS packages (5:01)
SSIS project system (2:10)
What are packages? (2:08)
SSIS toolbox (4:02)
SQL Server Management Studio (1:41)
Lab 1a: Installing SQL Server Data Tools (4:32)
Lab 1b: Overview of SSIS
Lab 1b: Walkthrough (9:50)
Quiz 1: Overview of SSIS
Module 2: Working with control flow
What is control flow? (3:06)
Precedence constraints (5:14)
Task disable and execute (2:20)
Naming annotating and grouping (2:13)
Visual layout controls (4:05)
Commonly used tasks (3:33)
Other built-in tasks (2:37)
Variables (6:32)
Expressions (5:20)
Parameters (2:31)
Script task (3:56)
Containers (8:28)
Task breakpoints (2:15)
Lab 2: Working with control flow
Lab 2: Walkthrough (21:38)
Quiz 2: Working with control flow
Module 3: Working with data flow
What is the data flow? (2:54)
Typical data flow (1:08)
Built-in data sources (4:59)
Setting component properties (1:37)
Normal flow vs error flow (2:30)
Built-in data destinations (1:47)
Bit bucket destination (2:06)
Built-in transformations (4:16)
Multi-output transformations (3:16)
Script component (3:16)
Data type conversions (2:46)
Data paths (3:48)
Lab 3: Working with data flow
Lab 3: Walkthrough (13:10)
Quiz 3: Working with data flow
Module 4: Configuration and deployment
Earlier version configuration (1:57)
Project configuration (0:54)
Property expressions (3:29)
Default parameter values (1:59)
SSIS catalog (2:20)
Project deployment (4:09)
Target versions (1:42)
Environments (4:23)
SSIS Catalog programmability (2:04)
Deploying to Azure Data Factory (2:08)
Lab 4: Configuration and deployment
Lab 4: Walkthrough (4:01)
Quiz 4: Configuration and deployment
Module 5: Scheduling and security
Scheduling package execution (2:37)
Monitoring and logging (3:50)
Advanced package logging (1:10)
Credentials and proxy accounts (2:58)
Lab 5: Scheduling and security
Lab 5: Walkthrough (5:03)
Quiz 5: Scheduling and security
Module 6: Advanced tasks and transforms
Data profiling task (4:45)
Lookup transform (3:58)
Cache transform (1:29)
Fuzzy lookup and fuzzy grouping transforms (2:06)
Bulk insert task (1:09)
Pivot and unpivot transforms (2:17)
Slowly-changing dimension wizard (7:53)
Change data capture integration (1:01)
Quiz 6: Advanced tasks and transforms
Module 7: Reliability and performance
Designing for reliability (1:04)
Designing for restartability (1:45)
Avoid built-in checkpoints (1:48)
Blocking transformations (1:32)
T-SQL vs SSIS (1:38)
Avoiding index overhead (1:29)
Overhead from constraints (2:19)
Incremental data loads (2:40)
Quiz 7: Reliability and performance
Module 8: Next steps
Summary and further steps (0:47)
Lab 1a: Installing SQL Server Data Tools
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock