SQL Server 2008 Integration Services training course

Course Outline

Microsoft SQL Server Integration Services (SSIS) is a key Business Intelligence component of Microsoft SQL Server 2008 / SQL Server 2008 . It supersedes Data Transformation Services (DTS).

The main function of SQL Server Integration Services is Data Warehousing...SSIS allows you to build data integration and workflow applications, and includes commercial-class features for data extraction, transformation, and loading (ETL).

SSIS can also be used for automating maintenance of SQL Server databases, update multidimensional cube data.

Because of the similarities in architecture and functionality between SQL Server 2005 and SQL Server 2008, demonstrations and course labs will either be on SQL 2005 or SQL 2008 with any specific differences being demonstrated where necessary (usually in a short session at the end of each session).

Course Content

This course has been developed for real-world, commercial scenarios by our expert instructors. See below for detailed syllabus. If you have a technical question, please email [email protected]

Advanced SQL Server 2005 / 2008 Integration Services Training Course Outline

SSIS features for SSAS cubes

Fuzzy matching
Derived columns
Slowly changing dimension wizard
SSAS processing
SSAS XMLA

SSIS features for SSAS data mining models

SSAS DMX queries
Percentage and row sampling

Advanced tools

Comprehensive control flow and data
flow toolboxes tour
WMI DataReader
WMI EventWatcher
Web services

Advanced features

Checkpoints
Transactions
Debugging
SQL Server Compact destinations
XML sources

SSRS reports on SSIS packages

rsReportServer.config
rsReportDesigner.config
DataReader destination

Deployment and configuration

Deploying to files and SQL Server
Configuration files
Configuration during deployment
Configuration at run-time

Administration

Package security
Backing up packages
Reverse engineering packages