Enable Technology

Database 

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






Training Locations: Enable Technology run courses in Wolverhampton, Telford, Shrewsbury, Birmingham, Cannock, Walsall, Dudley, Sandwell, Bridgnorth, Lichfield, Burton-upon-Trent, Stafford, Redditch, Bromsgrove, Solihull, Tamworth, Worcester, Shropshire, Staffordshire, Worcestershire and across the West Midlands.




West Midlands Scheduled Courses: Excel VBA; MS Project, SSRS; SQL; Crystal Reports; HTML;Adobe Illustrator; ASP.NET; Dreamweaver; Flash; Photoshop; InDesign; Google Scripting; Visio; PHP; Microsoft Access; JQuery JavaScript; Web Development; Office;

Birmingham Scheduled Courses: SQL; Excel VBA; MS Access;Photoshop; Adobe Illustrator; InDesign; Dreamweaver; MS Project;Visio; Flash; SSRS;PHP; JavaScript JQuery; HTML CSS; Microsoft Office;

Wolverhampton Scheduled Courses: Microsoft Access; Excel VBAMS Project; Visio; Adobe Illustrator; Photoshop; Dreamweaver; InDesign; Flash; HTML CSS; JavaScript; SQL; Microsoft Office; Adobe

Telford Scheduled Courses: SQL; Excel VBA; MS Project; Visio; PowerPoint; Photoshop; Adobe InDesign; Illustrator; Dreamweaver; Web Design; Office;

Cannock Scheduled Courses: Excel VBA; PHP; Microsoft Access; Visio; MS Project; PowerPoint; Dreamweaver; Photoshop; InDesign; Adobe Illustrator; Flash; JavaScript; HTML CSS;

Walsall Scheduled Courses: Excel; Access; MS Project; Visio; Photoshop; InDesign; Adobe Illustrator; Dreamweaver; Flash; SQL; JavaScript; HTML CSS;

Dudley Scheduled Courses: Excel; MS Access; SQL; MS Project;Visio; Adobe Illustrator; InDesign; Photoshop; Dreamweaver; Flash; JavaScript; HTML CSS;

Sandwell Scheduled Courses: Access;Excel; Microsoft Project; Visio; PowerPoint; Adobe Illustrator; Photoshop; Adobe InDesign; Dreamweaver; Flash; JavaScript; HTML CSS; SQL;

Shropshire Scheduled Courses: Illustrator; InDesign; Adobe; Dreamweaver; Flash; Photoshop; Excel; Project; Visio; PowerPoint; Office; JavaScript; HTML; Access;

Staffordshire Scheduled Courses: Illustrator; InDesign; Photoshop; Dreamweaver; Flash; Adobe; Excel;