MicroSoft SSIS

Course Overview:

SSIS training course, you'll gain the skills to migrate and transform data with SQL Server Integration Services. You learn to solve data management problems by creating dynamic packages for migrating, processing, and reporting on data for business intelligence.

Course Content:

Introduction

♦ SSIS Introductions

♦ Control Flow

♦ Data Flow

♦ Precedence constraint & Expressions

♦ Sequence Container

♦ Annotation

♦ Data Flow Components

♦ Data viewer

♦ Copy

♦ OLEDB Source

♦ OLD Destination

♦ Audit

♦ Character Map

♦ Conditional Split

♦ Row sampling

♦ Percentage sampling

♦ Excel Source

Flat File Source

?Control Flow Components

? Sequence Containers

? For loop

? For each loop

♦ Variables with default values

♦ Variables with dynamic values through Expressions

♦ Dynamic loading of Excel files into SQL target

♦ FTP Task

♦ Execute SQL Task – Basic

♦ Execute SQL task with parameter and with the result

♦ Multicast

♦ Data conversion / Type Cast

♦ Sort

♦ Merge

♦ Union all

♦ Aggregate

♦ Derived

♦ Row Count

♦ Breakpoints

♦ Merge join

♦ Flat File Destination

♦ Excel Destination

♦ OLEDB Command

♦ Cache transformation (target is cashed)

♦ Lookup

♦ SCD (type 1, type 2)

♦ Breakpoints

Script task

♦Bulk Insert Task (sending FF – SQL)

♦Execute package

♦Execute process

            ♦ ERROR Output in DF

♦ File system Task

♦ Send Mail Task

♦ Logging

♦ Checkpoints (restart ability)

♦ Jobs (Scheduling)

♦ Deployment

♦Configurations.