Aller au menu Aller au contenu Aller au pied de page

Purpose(3)

Understand SSIS architecture and components : Identify the tool's functional bricks and structure an ETL project.

Building robust, automated packages : Create data flows, use transformations, expressions, variables and events.

Ensure quality, monitoring and maintenance of flows : Implement logging, error handling and package reusability.

Content

Introduction to SSIS and its environment

Control flow creation and management

Variables, parameters and expressions

Data manipulation and transformation

Data flow design

Event management, errors and logging

Prerequisites(1)

Duration 3 jours

SSIS Fundamentals

This 3-day, 6-module training course introduces you to SQL Server Integration Services (SSIS), Microsoft's ETL solution. Learn how to create packages, automate data flows and efficiently integrate your sources in a robust BI environment.

References : FMA25

Download the training course