MS SQL Server 2012 / 2014 / 2016 Integration Services (SSIS)


overall satisfaction for this course

?Average calculated from scores obtained from 430 participants who took this course.
  • Duration 2 days
  • Regular fee 945
  • Preferential fee 795?
  • Locations
    • Montreal
    • Quebec City
  • Top pick
  • Laboratory

Formation path :

Databases Training Paths

View path


To provide the knowledge and skills required to make effective use of MS SQL Server Integration Services (SSIS).

Targeted audience

ETL developers.



Special Note

Customer Testimonials

Coverage of all elements to fully understand SSIS.

Simon F. / Ingénieur, Caisse de dépôt et placement du Québec


  • SSIS Architecture and the SSIS development environment
  • Key SSIS concepts: containers, tasks, precedence constraints, data streams, connectivity, variables, and package configurations
  • Creation of a control stream and package data
  • Component connection and data streams
  • Designing high-performance, extensible packages
  • Designing packages for complex tasks
  • Debugging SSIS packages: executing a package, defining breakpoints, adding a data inspector
  • Controlling the progress of data streams
  • Configuring and deploying SSIS packages
  • Switching between project mode and package mode
  • Deploying packages to SSIS databases
  • Using SSIS ETL features (Extract, Transform and Load)
  • Using transformations: derived columns, slowing changing dimensions, fuzzy lookups and fuzzy grouping


*Unless stated otherwise, all sessions are in French.
  • Montreal

    November 29 to November 30 2017

  • Quebec City

    January 17 to January 18 2018

  • Montreal

    February 19 to February 20 2018

  • Montreal

    June 4 to June 5 2018

Trainer(s) assigned(s)

Other course(s) in this category