Microsoft SQL Server 2008 Integration Services

Global Knowledge Canada
Calgary, Edmonton, Halifax, Montreal, Ottawa, Quebec City, Toronto, Vancouver, Winnipeg, Canada

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' Learn how to implement an Integration Services solution in an organization. In the course, you will learn to develop, deploy, and manage Integration Services packages.

This course incorporates material from the Official Microsoft Learning Product (OMLP) 6235: Implementing and Maintaining Microsoft SQL Server 2008 Integration Services.

What You’ll Learn


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
Course Outline


1. Introduction to SQL Server 2008 Integration Services
Overview of SQL Server Integration Services
Using Integration Services Tools
2. Developing Integration Services Solutions
Creating an Integration Services Solution
Using Variables
Building and Running a Solution
3. Implementing Control Flow
Control Flow Tasks
Control Flow Precedent Constraints
Control Flow Containers
4. Implementing Data Flow
Data Flow Sources and Destinations
Basic Data Flow Transformations
Advanced Data Flow Transformations
Data Flow Paths
5. Implementing Logging
Overview of Integration Services Logging
Enabling and Configuring Logging
6. Debugging and Error Handling
Debugging a Package
Implementing Error Handling
7. Implementing Checkpoints and Transactions
Implementing Checkpoints
Implementing Transactions
8. Configuring and Deploying Packages
Package Configurations
Preparing and Deploying Packages
9. Managing and Securing Packages
Managing Packages
Securing Packages
Labs


Lab 1: Introduction to SQL Server Integration Services
Using the Import and Export Wizard
Running an Integration Services Package
Import Data Using the Import and Export Wizard
Managing Packages
Lab 2: Developing Integration Services Solutions
Creating an Integration Services Project
Implementing a Package
Building and Running an Integration Services package
Lab 3: Implementing Control Flow
Creating a Simple Control Flow
Configuring Precedence Constraints
Using Containers
Lab 4: Implementing Data Flow
Transferring Data
Implementing Transformations
Using Data Viewers
Configuring Error Output
Lab 5: Implementing Logging
Configuring Logging
Implementing Custom Logging
Lab 6: Debugging and Error Handling
Debugging a Package
Implementing Error Handling
Controlling Failure Behavior
Lab 7: Implementing Checkpoints and Transactions
Implementing Checkpoints in a Package
Implementing Transactions in a Package
Implementing a Native Transaction
Lab 8: Configuring and Deploying Packages
Creating a Package Configuration
Preparing a Package for Deployment
Deploying a Package
Lab 9: Managing and Securing Packages
Importing a Package
Configuring, Executing, and Monitoring a Package
Scheduling a Package
Securing a Package
...''

Elements of this syllabus are subject to change.

Phone:1-800-COURSES

School Address:

Global Knowledge - Canada
535 Legget Drive
Suite 200
Kanata, ON K2K 3B8 Canada



Jobs & Resumes: Calgary, Edmonton, Halifax, Montreal, Ottawa, Quebec City, Toronto, Vancouver, Winnipeg
Houses & Roommates: Calgary, Edmonton, Halifax, Montreal, Ottawa, Quebec City, Toronto, Vancouver, Winnipeg
Travel Agencies: Calgary, Montreal, Ottawa, Toronto, Vancouver, Winnipeg

Search other schools for Microsoft SQL Server 2008 Integration Services training resources.

Communication and Negotiation Skills
Six Sigma Master Black Belt Certification
six sigma black belt certification
Six Sigma Jumpstart
Six Sigma Green Belt Certification
writing effective requirements
requirements development and management
CBAP Exam Prep
Implementing a SQL Server 2008 Database
microsoft sql server 2008 analysis services
microsoft sql server 2008 reporting services
SQL Server 2008
Writing Queries Using Microsoft SQL Server 2008 Transact-SQL
Designing a Reporting Solution Architecture Using Microsoft SQL Server 2005 Reporting Services
microsoft sql server 2005 reporting services
Database Administrator
SQL Server 2005 Administration
sql server 2005 for business intelligence
SQL Server 2005 for Developers

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: We serve the schools and students around the world. Major visitors come from India, United States, United Kingdom, Canada, Australia, Philippines, Malaysia, Singapore and South Africa.