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


overall satisfaction for this course

?Average calculated from scores obtained from 380 participants who took this course.
  • Duration 2 days
  • Regular fee 895
  • Preferential fee 750?
  • 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

Interesting and exactly what I needed.

Colin C. / Analyste sénior, Configuration intégration, Purkinje Inc.


  • SSIS Architecture and the SSIS development environment
  • Fundamental concepts of SSIS: 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
  • 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

    October 31 to November 1 2016

  • Quebec City

    January 16 to January 17 2017

  • Montreal

    February 20 to February 21 2017

  • Montreal

    June 15 to June 16 2017

Trainer(s) assigned(s)

Other course(s) in this category