MS515

MS SQL Server 2014 / 2016 Integration Services (SSIS)

93%

overall satisfaction for this course

?Average calculated from scores obtained from 478 participants who took this course.
See the training dates
  • Duration 2 days
  • Regular fee 955
  • Preferential fee 860?
  • Locations
    • Quebec City
    • Montreal
  • Top pick
  • Laboratory
    course

Objectives

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

Targeted audience

ETL developers.

Prerequisite

None.

Special Note

Training Details

Content

  • 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

Customer Testimonials

Gives practical tools and concrete examples.

Marc P. / Conseiller Senior, Banque Nationale du Canada

Select the training date*

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

    September 30 to October 1 2019

  • Montreal

    October 7 to October 8 2019

  • Montreal

    April 8 to April 9 2020

  • Quebec City

    April 8 to April 9 2020 - Virtual Classroom

Trainer(s) assigned(s)