Course Syllabus

What you’ll learn

Deciding on full or incremental loading

Isolating ETL data

Creating an ETL script

ETL abstraction layers

The design environment

Control flows

Data sources

Data transformations

Data destinations

Precedence constraints

Connection managers

Execute SQL tasks

Progress/execution results

Resetting destination database

Data flows

Data flow paths

Error output paths

Configuring data sources and destinations

Executing SSIS packages

Deploying SSIS packages