Enable Technology

SQL Server Integration Services 

Microsoft SQL Server 2008 Integration Services SSIS




Course Overview


This two day course will enable technology professionals with little or no ETL experience to be comfortable and productive with the SSIS tools and technologies. In this course you will learn about the Business Intelligence Development Studio (BIDS) and working with Control and Data Flows to build workflows to extract, transform, and load data using a variety of data sources, transformations, and destinations. 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


A Guided Tour of Integration Services
Understanding Integration Services 
Exploring and Executing an Integration Services Package in BIDS 
Exploring and Executing a Package Outside of BIDS 

Control Flow
Overview of Control Flow in Integration Services 
Working with Workflow Tasks 
Precedence Constraints 

Data Flows
The Data Flow Task 
Data Viewers 
Data Flow Transformations 

Variables and Configurations
Understanding Variables 
Using Variables in Control Flow 
Using Variables in Data Flow 
Configurations 
Using Variables and Configurations between Packages 

Advanced Control Flow
Advanced Control Flow Overview 
Using Containers 
Transactions Support in Integration Services

Error Handling and Logging 
When Things Go Wrong 
Checkpoints 
Handling Errors and Debugging 
Packaging Logging 
Event Handling 

Advanced Data Flow
Synchronous and Asynchronous Transformations 
Using Advanced Transformations 
Handling Slowly Changing Dimensions 

Package Deployment
Deploying Packages 
Create a Package Deployment Utility 
Installing a Package 
Redeploying Updated Packages 

Package Management
Overview of Package Management 
Managing Integration Services Packages 
Executing Packages 
Integration Services Security 

Scripting and Custom Components
Extending Integration Services Capabilities through Code 
Scripting in Control Flows with the Script Task 
Scripting in Data Flows with the Script Component 
Custom Integration Services Components 

Best Practices
Best Practices for Using Integration Services 
Best Practices for Package Development and Design 
Data Flow Best Practices 
Deployment and Management Best Practices 

Going Beyond ETL
Using Integration Services Beyond ETL 
Migrating and Maintaining SQL Servers with Integration Services 
Working with Analysis Services 
Working with Windows Management Instrumentation


Email us about this courses


Telephone on 01952 305730