SQL Server Integration Services 2005

Quanta Training
In Worcester

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

Important information

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

The course will enable delegates to design and use Integration Services packages.
Suitable for: The course is aimed at people who are new to Integration Services.

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

Course programme

THE COURSE
The course will enable delegates to design and use Integration Services packages. Packages will be designed using Business Intelligence Development. 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.

WHO SHOULD ATTEND
IT professionals who need to build and use Integration Services packages for Microsoft SQL Server 2005.

PRE-REQUISITES
No previous knowledge of Microsoft SQL Server Integration Services 2005 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 TOPICS

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

Introduction to Control Flow
Overview of Control Flow in SSIS
Control Flow Tasks
Workflow Tasks
Other SQL Server Operations Tasks
Precedence Constraints
Data Processing Tasks

Introduction to Data Flows
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

Package Deployment
Overview of Deploying Packages
Deployment Challenges
Create a Package deployment utility
The Package Installation Wizard
Deploy a Package to the File System
Deploy a Package to SQL Server
Redeploying Updated Packages

Package Management
Overview of Package Management
Managing packages with DTUtil
Managing packages with SQL Server Management Studio
Executing packages
Scheduling packages with SQL Server Agent
SSIS Security


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