SQL Server Integration Services 2008

Quanta Training
In Worcester

£680
+ VAT
Want to speak to an Advisor about this course?

Important information

Typology Course
Start Worcester
Duration 2 Days
  • Course
  • Worcester
  • Duration:
    2 Days
Description


Suitable for: IT Professionals who need to build and use Integration Services packages for Microsoft SQL Server 2008.

Important information
Venues

Where and when

Starts Location
On request
Worcester
8-10 The Moors, WR1 3EE, Worcestershire, England
See map
Starts On request
Location
Worcester
8-10 The Moors, WR1 3EE, Worcestershire, England
See map

Frequent Asked Questions

· Requirements

No previous knowledge of Microsoft SQL Integration Services 2008 is required. A basic knowledge of database principles, Microsoft Windows and Microsoft SQL Server is required. This could be gained from our SQL Server Essentials course or through work experience.

Course programme

The course will enable delegates to design and use SQL Server Integration Services projects. Packages will be deigned using Business Intelligence Development Studio. The course includes connections, control flows, data flows, variables, logging and error handling. The course is aimed at people who are new to Integration Services. Exercises are included to consolidate the skills taught.

COURSE TOPICS

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

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

Introduction to Data Flow
Data Flow Overview
Data Flow Pipeline
Data Flow Sources
Data Flow Destination
Data Viewers
Data Transformations

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


Error Logging and Handling
Error Logging and Handling Overview
Checkpoints
Package Logging
Event Handling

Achievements for this centre


Students that were interested in this course also looked at...
See all