Implementing and Maintaining
Microsoft SQL Server 2005 Integration Services
Course 2792: Three days; Instructor-Led
|
About
this Course Elements of this syllabus are subject to change. This three-day instructor-led course teaches students how to
implement an Integration Services solution in an organization. The course
discusses how to develop, deploy, and manage Integration Services packages. |
|
Audience
Profile This course is intended for information technology (IT)
professionals and developers who need to implement data transfer or extract,
transform, and load (ETL) solutions by using Microsoft SQL Server 2005
Integration Services. |
|
At
Course Completion After completing this course, students will be able to: ·
Describe
SQL Server Integration Services and its tools. ·
Create
an Integration Services package. ·
Implement
control flow in an Integration Services package. ·
Implement
data flow in an Integration Services package. ·
Implement
logging in an Integration Services package. ·
Debug
and implement error handling in an Integration Services package. ·
Implement
checkpoints and transactions in an Integration Services package. ·
Deploy
an Integration Services package. ·
Manage
and secure an Integration Services package. |
Prerequisites
Before
attending this course, students must have:
- Exposure
to enterprise data import and export scenarios.
- Experience
navigating the Microsoft Windows Server environment.
- Experience
with Microsoft SQL Server, including:
- SQL
Server Agent.
- SQL
Server query language (SELECT, UPDATE, INSERT, and DELETE).
- SQL
Server System tables.
- SQL Server accounts (users and permissions).
Course
OutlineModule 1: Introduction to SQL Server 2005 Integration
Services
This module introduces the role that Integration Services
plays in extracting, transforming, and loading data. This module also describes
the tools that you can use to build and manage Integration Services solutions.
Lessons
·
Overview of Integration
Services Solutions
·
Integration Services Tools
Lab : Using SQL Server
Integration Services
·
Using the Import and
Export Wizard
·
Running an Integration
Services Package
After completing this module,
students will be able to:
·
Describe Integration
Services solutions.
·
Use Integration Services
tools.
Module 2: Developing
Integration Services Solutions
This module provides an overview of the development tasks
that are involved in creating an Integration Services package. After completing
this module, you will be able to create a basic package.
Lessons
·
Creating an Integration
Services Solution
·
Using Variables
·
Building and Running a
Solution
Lab : Implementing an
Integration Services Solution
·
Creating an Integration
Services Project
·
Implementing a Package
·
Building and Running an
Integration Services Project
After completing this module,
students will be able to:
·
Create a SQL Server
Integration Services solution.
·
Use variables.
·
Build and run a solution.
Module 3: Implementing
Control Flow
This module introduces the tasks and precedence constraints
that you can use to implement control flow in an Integration Services package.
Lessons
·
Control Flow Tasks
·
Control Flow Precedence
Constraints
·
Control Flow Containers
Lab : Implementing Control
Flow
·
Creating a Simple Control
Flow
·
Configuring Precedence
Constraints
·
Using Containers
After completing this module,
students will be able to:
·
Configure control flow
tasks.
·
Configure control flow
precedence constraints.
·
Configure control flow
containers.
Module 4: Implementing
Data Flow
This module describes the data flow sources,
transformations, and destinations that you can use to implement a data flow
task in an Integration Services control flow. It also explains how to use data
flow paths to direct valid and invalid rows through the data flow.
Lessons
·
Data Flow Sources and
Destinations
·
Data Flow Transformations
·
Data Flow Paths
Lab : Implementing Data
Flows
·
Transferring Data
·
Implementing
Transformations
·
Using Data Viewers
·
Configuring Error Output
After completing this module,
students will be able to:
·
Implement data flow
sources and destinations.
·
Implement data flow
transformations.
·
Implement data flow paths.
Module 5: Implementing
Logging
This module discusses how to use logging in an Integration
Services package, and explains how to configure and use logging providers to
generate information about a package’s execution.
Lessons
·
Overview of Integration
Services Logging
·
Implementing Logging
Lab : Implementing Logging
·
Configuring Logging
·
Implementing Custom
Logging
After completing this module,
students will be able to:
·
Describe Integration
Services logging.
·
Implement logging.
Module 6: Debugging and
Error Handling
This module describes how to debug Integration Services
packages by using the debugging tools in Business Intelligence Development
Studio. It then explains how to implement error-handling logic in an
Integration Services package.
Lessons
·
Debugging a Package
·
Implementing Error
Handling
Lab : Debugging and Error
Handling
·
Debugging a Package
·
Implementing Error
Handling
·
Controlling Failure
Behavior
After completing this module,
students will be able to:
·
Debug a package.
·
Implement error handling.
Module 7: Implementing
Checkpoints and Transactions
This module explains what checkpoints are and how to
implement them. It then discusses transactions, and describes how you can
implement transactional data access logic in an Integration Services package.
Lessons
·
Implementing Checkpoints
·
Implementing Transactions
Lab : Implementing
Checkpoints and Transactions
·
Implementing Checkpoints
in a Package
·
Implementing Transactions
in a Package
·
Implementing a Native
Transaction
After completing this module,
students will be able to:
·
Implement checkpoints.
·
Implement transactions.
Module 8: Deploying
Packages
This module discusses how to create Package Configurations
and how to deploy Integration Services packages to production servers.
Lessons
·
Package Configurations
·
Deploying Packages
Lab : Deploying
Integration Services Packages
·
Creating a Package
Configuration
·
Preparing a Package for
Deployment
·
Deploying a Package
After completing this module,
students will be able to:
·
Implement package
configurations.
·
Deploy packages.
Module 9: Managing and
Securing Packages
This module describes the management tasks that relate to
Integration Services packages and explains how to perform those tasks by using
the Integration Services management tools. It also describes how to secure
Integration Services packages.
Lessons
·
Managing Packages
·
Securing Packages
Lab : Managing and
Securing Packages
·
Importing a Package
·
Configuring and Executing
a Package
·
Scheduling a Package
·
Securing a Package
After completing this module,
students will be able to:
·
Manage packages.
·
Secure packages.
Solutient
Corporation of Ohio
6133
Rockside Road, Suite 100 – Cleveland, OH
44131
FOR MORE
INFORMATION, CALL 216-654-0025