MS515

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

94%

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
    • Quebec City
    • Montreal
  • Top pick
  • Laboratory
    course
Parcours

Formation path :

Databases Training Paths

View path
SUMMARY
DETAILS

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

Customer Testimonials

Interesting and exactly what I needed.

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

Content

  • 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

DATES*

*Unless stated otherwise, all sessions are in French.
  • 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