Waterloo - 180 Northfield Drive West

180 Northfield Drive West, Waterloo, Canada, N2L 0C7

Maximise opportunities in this forward-thinking city, a knowledge center home to several tech giants. Our well-connected 180 Northfield Drive West centre is on the city's Corporate Campus near the prestigious University of Waterloo.

Explore Our Courses

Introduction to SQL Server 2022 Integration Services (SSIS)

 28 Hours
This instructor-led, live training in Waterloo (online or onsite) is aimed at beginner-level data professionals who wish to learn how to design, implement, and manage SSIS packages to perform data integration and transformation tasks. By the end of this training, participants will be able to:
  • Understand the architecture and components of SSIS.
  • Design and implement ETL processes using SSIS.
  • Use SSIS tools to develop, deploy, and manage data integration solutions.
  • Troubleshoot and optimize SSIS packages for performance and reliability.
Read more...

Introduction to SQL Server 2012 Integration Services (SSIS)

 28 Hours
This instructor-led, live training in Waterloo (online or onsite) is aimed at beginner to intermediate-level developers and database administrators who wish to gain proficiency in SQL Server 2012 Integration Services. By the end of this training, participants will be able to:
  • Understand the principles of ETL and the role of SSIS.
  • Create, deploy, and manage SSIS packages.
  • Design and implement Control Flow to define the flow of tasks in a package.
  • Implement Workflow and set up constraints for effective task execution.
  • Construct Data Flows to extract, transform, and load data.
  • Work with Variables and Containers to enhance package flexibility.
  • Manage Transactions to ensure data consistency.
  • Implement effective error handling and debugging techniques.
  • Set up Logging for tracking and monitoring.
  • Handle Slowly Changing Dimensions for managing changing data.
  • Deploy a Package for production use.
  • Implement Security measures to protect sensitive data.
  • Utilize Scripting to extend SSIS functionality.
  • Apply Best Practices for efficient and maintainable SSIS solutions.
Read more...

Last Updated:

Testimonials (1)

The thorough / hands-on knowledge the trainer has.

Pieter Peirs

Course - Introduction to SQL Server 2012 Integration Services (SSIS)

Upcoming Courses

Introduction to SQL Server 2022 Integration Services (SSIS)

2025-05-26 09:30
28 hours
Waterloo - 180 Northfield Drive West
CA$ 7,027 (Online)
CA$ 8,027 (Classroom)

Introduction to SQL Server 2012 Integration Services (SSIS)

2025-06-09 09:30
28 hours
Waterloo - 180 Northfield Drive West
CA$ 7,027 (Online)
CA$ 8,027 (Classroom)

Introduction to SQL Server 2012 Integration Services (SSIS)

2025-06-23 09:30
28 hours
Waterloo - 180 Northfield Drive West
CA$ 7,027 (Online)
CA$ 8,027 (Classroom)

Introduction to SQL Server 2012 Integration Services (SSIS)

2025-07-07 09:30
28 hours
Waterloo - 180 Northfield Drive West
CA$ 7,027 (Online)
CA$ 8,027 (Classroom)

Introduction to SQL Server 2012 Integration Services (SSIS)

2025-07-21 09:30
28 hours
Waterloo - 180 Northfield Drive West
CA$ 7,027 (Online)
CA$ 8,027 (Classroom)

Other regions in Canada

Other Countries

These courses are also available in other countries
Online MS SSIS training in Waterloo, SSIS (SQL Server Integration Services) training courses in Waterloo, Weekend SQL Server Integration Services courses in Waterloo, Evening SSIS training in Waterloo, MS SSIS instructor-led in Waterloo, MS SQL Server Integration Services one on one training in Waterloo, Microsoft SSIS private courses in Waterloo, MS SQL Server Integration Services classes in Waterloo, SQL Server Integration Services (SSIS) on-site in Waterloo, SQL Server Integration Services (SSIS) boot camp in Waterloo, Evening MS SSIS courses in Waterloo, SSIS instructor-led in Waterloo, MS SSIS instructor in Waterloo, SQL Server Integration Services coaching in Waterloo, SSIS trainer in Waterloo, Weekend MS SQL Server Integration Services training in Waterloo, Online SQL Server Integration Services training in Waterloo