Enable Technology

SQL Server Integration Services 

Microsoft SQL Server 2005 Integration Services SSIS

Course Overview

This two day course will familiarise participants with SQL Server Integration Services 2005 (SSIS) tools and technologies. In this course you will learn about the SQL Server Management Studio (SSMS) and building Database Maintenance Plans. You will be introduced to the Business Intelligence Development Studio (BIDS) and working with Control Flow and Data Flow. You will also become familiar with SSIS package management and package deployment along with learning to write solid code using debugging, error handling and logging techniques.

Duration: 2 day course

Course Content

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 
Changes in SQL Server 2005 Service Pack 2 

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 
Configuration discipline 

Debugging , Error Handling and Logging
SSIS debugging overview 
Breakpoints in SSIS 
SSIS debugging windows 
Control Flow: The OnError 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

Email us about this courses

Telephone on 01952 305730