Advanced SSIS


  • Performance tuning for SSIS
  • How to extend SSIS using script tasks and components
  • SSIS integration with SSAS and DQS
  • Data warehouse loading patterns
This course includes:

Course Description

For the advanced ETL developer and the SSIS user looking to become more effective, our Advanced SSIS course teaches how to use SSIS in your enterprise to solve common extract, transform and load (ETL) challenges. Much of this course focuses on implementing common real-world SSIS patterns taught from the experts of SSIS. Be prepared for in-depth SSIS training with advanced discussion in many areas.


Click here for a downloadable PDF



Module 00 | Class Introduction
04m 03s total


Module 00A | Class Introduction
04m 03s


Module 01 | Loading a Data Warehouse
124m 46s total


Module 01A | Why a Data Warehouse
18m 27s


Module 01B | Loading a Dimension Table
27m 19s


Module 01C | Loading a Type 1 Dimension
24m 38s


Module 01D | Loading a Type 2 Dimension
18m 21s


Module 01E | Upsert Pattern
21m 08s


Module 01F | Scaling Out Dimension Loads
15m 33s


Module 02 | Loading a Fact Table
20m 13s total


Module 02A | Loading a Fact Table
20m 13s


Module 03 | Incremental Load Pattern
51m 09s total


Module 03A | Using a Control Table
25m 56s


Module 03B | Change Data Capture
25m 53s


Module 04 | Performance Tuning
55m 58s total


Module 04A | Source Optimization
30m 06s


Module 04B | Transform Optimization
15m 40s


Module 04C | Destination Optimization
10m 12s


Module 05 | Scaling out SSIS
40m 66s total


Module 05A | Process Task
25m 43s


Module 05B | Process Tasks with T-SQL
15m 23s


Module 06 | Restartability Patterns in SSIS
25m 74s total


Module 06A | Checkpoints
10m 40s


Module 06B | Transactionss
15m 34s


Module 07 | SSIS Scripting
38m 06s total


Module 07A | Basics
18m 02s


Module 07B | Common Examples
20m 04s


Module 08 | Data De-Duplication
31m 69s total


Module 08A | Fuzzy Grouping
19m 40s


Module 08B | Fuzzy Lookup
12m 29s


Module 09 | Advanced Design Patterns
25m 74s total


Module 09A | Term Extraction
07m 09s


Module 09B | Unpivot Transform
08m 38s


Module 09C | Data Mining
10m 27s


Module 10 | SSIS Administration
41m 49s total


Module 10A | Deployment
29m 01s


Module 10B | Environments
12m 48s


Module 11 | Data Quality
33m 87s total


Module 11A | Data Profiling Task
12m 33s


Module 11B | Data Quality Services
21m 54s


Module 12 | Master Child Design Pattern
12m 37s total


Module 12A | Master Child Design Pattern
12m 37s



Training Content Manager
Mitchell Pearson has been with Pragmatic Works for 8 years as a Data Platform Consultant and the Training Content manager. Mitchell has authored books on SQL Server, Power BI and the Power Platform. Data Platform experience includes designing and implementing enterprise level Business Intelligence solutions with the Microsoft SQL Server stack (T-SQL, SSIS, SSAS, SSRS), the Power Platform and Microsoft Azure.


Click Here To Learn More About Mitchell And See Certifications And Reviews

System Requirements

  • Windows, 7, 8 or 10
  • 1 GHz or faster CPU
  • 1 GB of available RAM (recommended 2 GB)
  • 5 GB of free hard drive space
  • Microsoft Excel 2010 but Excel 2013 is preferred

What to Know Before Class

This class assumes you know the basics of SSIS and takes you from the novice level to a more effective, advanced ETL developer level. We recommend our Introduction to SSIS for those new to SSIS. Having an understanding of Visual Basic is helpful, but not required, for this course.

Despite having several years of experience using SSIS, by doing this Advanced SSIS course I certainly learned new ideas, especially in terms of performance and scalability.

Jayasurya P.

Just wanted to say thank you to Mitchell, I have taken several courses regarding Power BI and MS SQL server technologies and I really enjoy how he explains all the content, there is clarity and structure, I feel engaged with the course.

Jordi A.

I really like the fact that there were overviews of other features like MDM. I really learned a lot from this course!!! THANKS!

Robert K.

Start With The Free Community Plan

Pragmatic Works free community plan gives you lifetime access to 7 Microsoft “in a day” courses on Power BI, Excel, Power Apps, Azure Synapse, Power Automate, Paginated Reports and Chatbots.



• Get preview access to all 70+ courses & custom Learning Paths for 7 days

• Labs and files included

• Access courses from our mobile app or desktop

• Access quizzes to practice while you learn

Get Instant Access Now!