Introduction to SSIS

Part Of The On-Demand Courses


  • How to create an SSIS package to load to a database
  • How to make dynamic packages that work and self-heal in the event of a failure
  • How to use SSIS in your environment
This course includes:
  • Course Description
  • Outline
  • Instructor
  • System Requirements
  • What to Know Before Class

Course Description

This course is designed to help you understand all aspects of SQL Server Integration Services (SSIS), the ETL tool of choice for SQL Server users. We will use a variety of lab exercises and small projects to ensure you gain familiarity with how the design and execution of environments work, and prepare you to build your own real world applications using this SQL Server application. Students will learn real world uses for SSIS.


Click here for a downloadable PDF



Module 00 | Getting Started
06m 53s total


Module 00A | Getting Started
06m 53s


Module 01 | SSIS Overview
15m 37s total


Module 01A | SSIS Overview
15m 37s


Module 02 | Introduction to the Development Environment
72m 97s total


Module 02A | Introduction to SQL Server Data Tools
25m 31s


Module 02B | Connection Managers
16m 54s


Module 02C | Precedence Constraints and Control Flow Tasks
31m 12s


Module 03 | Loading Data with the Data Flow
96m 82s total


Module 03A | Common Sources
24m 54s


Module 03B | Common Transforms
41m 07s


Module 03C | Common Destinations
31m 21s


Module 04 | Using Variables, Parameters and Expressions
36m 76s total


Module 04A | Using Variable and Parameters
15m 41s


Module 04B | SSIS Expression Language and Parameterized Objects
21m 35s


Module 05 | Using Containers
42m 53s total


Module 05A | Grouping, Sequence and For Loop Container
18m 20s


Module 05B | For Each Loop Container
24m 33s


Module 06 | Troubleshooting SSIS
15m 54s total


Module 06A | Troubleshooting SSIS
15m 54s


Module 07 | Loading a Dimension
64m 44s total


Module 07A | Designing a Data Warehouse
36m 31s


Module 07B | Loading Dimension Tables
28m 13s


Module 08 | Loading a Fact Table
26m 38s total


Module 08A | Loading a Fact Table
26m 38s


Module 09 | Deploying SSIS Packages
20m 27s total


Module 09A | Deploying SSIS Packages
20m 27s


Module 10 | Configuring SSIS Packages for Portability
21m 51s total


Module 10A | Configuring SSIS Packages for Portability
21m 51s


Module 11 | SSIS Server Executions
24m 35s total


Module 11A | SSIS Server Executions
24m 35s


Module 12 | Setting Up Auditing and Notification
15m 15s total


Module 12A | Setting Up Auditing and Notification
15m 15s



Training Content Manager

As a Training Content Manager, Consultant and Trainer with Pragmatic Works, Manuel uses his extensive knowledge of the BI Stack (SSRS, SSIS, SSAS etc.) to deliver exciting and engaging content. He also has experience with T-SQL, DAX, Power Platform and Azure Data Services. Manuel, however, is known for his impressive knowledge of the Microsoft Power BI tool. A native of Puerto Rico, He graduated from the University of Central Florida and loves being involved in the world of business intelligence. Manuel is a thought leader in the BI community.

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
  • AdventureWorks2008R2 or AdventureWorks2012 databases installed on the instance
  • AdventureWorksDW2008R2 or AdventureWorksDW2012 databases installed on the instance

What to Know Before Class

This course assumes that you have no previous knowledge of SSIS. In some of the scripting modules, it is useful (but not mandatory) that attendees have some Visual Basic experience. You will need to know how to run a query inside of SQL Server.


Excellent course, steady pace and the audience level is perfect for people who need the ground knowledge.

Imtiaz H.

I was very impressed with Manuel Quintana's public speaking skill. It had a friendly tone, helpful side comments and was captivating to listen. He came across as humble and confident helping listeners find their self-confidence with the respective technology.


I really enjoyed this class and found it very informative. I've been writing SSIS packages for a long time but have never taken a course. Many knowledge gaps were taken care of. Thanks!


Start your 7 day free trial

Pragmatic Works On-Demand Learning Platform gives you access to 60+ courses such as Power BI, Azure, SQL Server, Data Science, Business Intelligence Power Apps and more.

Instant Download | No Credit Card Required