Microsoft SQL Server Integration Services (SSIS) Course

Introduction to SQL Server Integration Services

• Product History

• SSIS Package Architecture Overview

• Development and Management Tools

• Deploying and Managing SSIS Packages

• Source Control for SSIS Packages

SSIS for DBAs: Using SQL Server Management Studio

• The Import and Export Wizard

• Importing and Exporting Data

• Working with Packages

• Database Maintenance Plans

• Creating Database Maintenance Plans using SSMS

• Scheduling and Executing Plans Examining Database Maintenance Plan Packages

Business Intelligence Development Studio

• Launching BIDS

• Project templates

• The package designer

• The Toolbox

• Solution Explorer

• The Properties window

• The Variables window The SSIS menu

Introduction to Control Flow

• Control Flow Overview

• Precedence Constraints

• The Execute SQL Task

• The Bulk Insert Task

• The File System Task

• The FTP Task

• The Send Mail Task

Advanced Control Flow

• Containers grouping and looping

• The Web Service Task

• The WMI tasks

• The Analysis Services tasks

• The Execute Process Task The Execute Package Task

Introduction to Data Flow

• Data Flow Overview

• Data Sources

• Data Destinations

• Data Transformations

• The Copy Column Transformation

• The Derived Column Transformation

• The Data Conversion Transformation

• The Conditional Split Transformation

• The Aggregate Transformation

• The Sort Transformation

• Data Viewers

Variables and Configurations

• Variables Overview

• Variable scope

• SSIS system variables

• Using variables in control flow

• Using variables in data flow

• Using variables to pass information between packages

• Property expressions

• Configuration Overview

• Configuration options

Debugging, Error Handling and Logging

• SSIS debugging overview

• Breakpoints in SSIS

• SSIS debugging windows

• Control Flow: The on Error event handler

• Data Flow: Error data flow

• Configuring Package Logging Built-in log providers

Advanced Data Flow

• Revisiting data sources and destinations

• The Lookup Transformation

• Getting Fuzzy: The Fuzzy Lookup and Fuzzy Grouping Transformations

• The Multicast Transformation

• The Merge and Merge Join Transformations

• The Data Mining Query Transformation

• The Data Mining Model Training Destination

• The Slowly Changing Dimension Transformation

Extending SSIS through Custom Code

• Introduction to SSIS scripting

• The SSIS script editor

• The SSIS object model

• Script in Control flow: The Script Task

• Script in Data flow: The Script Component

• Introduction to SSIS component development

SSIS Package Deployment

• Configurations and deployment

• The deployment utility

• Deployment options

• Deployment security

• Executing packages DTExec and DTExecUI

SSIS Package Management

• The SSIS Service

• Managing packages with DTUtil

• Managing packages with SQL Server Management Studio

• Scheduling packages with SQL Server Agent

SSIS 2012 new features

• CDC (Change data capture) control Flow & Data flow task

• SSIS Catalog Reports (Dashboard)

• Package upgrades from legacy to SSIS 2012