Advanced SSIS


What Will You Learn?

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


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.



Brian Knight is the owner and founder of Pragmatic Works and is a serial entrepreneur, starting up other companies throughout his prolific career. Brian is a contributing columnist at several technical magazines and also does regular webcasts. He is the author of more than 15 technical books.


What to Know Before the 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.

Curriculum For This Course

System Requirements

  • Microsoft Windows XP Professional, Microsoft Windows Server 2003, Microsoft Vista, Windows 7 or Windows 8
  • 1 GHz or faster CPU
  • 1 GB of available RAM (recommended 2 GB)
  • 20 GB of free hard drive space
  • SQL Server Developer, Standard or Enterprise Edition 2008/2008R2/2012/2014 (Many features discussed are Enterprise/Developer edition only)
    • SQL Server Database Engine
    • SQL Server Integration Services
    • SQL Server Analysis Services (Optional)
    • SQL Server Data Tools (SQL 2012/2014) or Business Intelligence Development Studio (SQL 2008/2008R2)
    • SQL Server Management Studio
    • Data Quality Services (SQL 2012/2014 only)
    • Data Quality Client (SQL 2012/2014 only)
    • Follow this installation guide: (https://file.ac/CtasreVWQEA/Pragmatic%20SSIS%20Master%20Installation%20Guide.docx)
  • AdventureWorks2008R2 or AdventureWorks2012 databases installed on the instance
  • AdventureWorksDW2008R2 or AdventureWorksDW2012 databases installed on the instance
  • HigherEd and HigherEdDW databases should be restored on the instance. The HigherEd database backup files can be found in the class download in C:\SSISMaster\databases

You may also like…