• Microsoft Gold Certified Partner
  • Cisco Partner Learning Associate
  • Better Business Bureau

Questions? Call us at (919) 336-1000


2792 Implementing and Maintaining Microsoft SQL Server 2005 Integration Services - Details

Return to All courses

Description:

In this course, students learn how to implement an Integration Services solution in an organization. The course discusses how to develop, deploy, and manage Integration Services packages.

More Information  

Duration

3 days

Who Should Attend

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.

Prerequisites

Exposure to enterprise data import and export scenarios. Experience navigating the Microsoft Windows Server environment. Experience with Microsoft SQL Server, SQL Server Agent, SQL Server query language, SQL. Server System tables, SQL Server accounts (users and permissions).

On 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.

Outline

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

Please call Jon Kudlick, Director of Sales at (919) 336-1000, ext. 1025 or email sales@nhrtp.com for class information.

Contact us to learn more about our courses and certifications.

Return to Top


News and Events

View all news

Top Certifications

"75 percent of managers believe that certified individuals are more productive and that certifications are important to team performance." - MCP Customer Satisfaction Study

Top Certifications in Information Technology Today

Why get certified? The importance of certifications. Read more...

 

What sets us apart

New Horizons Integrated Learning

For training to have a lasting and measurable impact, New Horizons understands that course content has to be designed and delivered in the context of our client’s specific environment and business need.  To achieve this, we blend custom content with leading edge and time honored training approaches, including Traditional Instructor-Led, Mentored Learning, Online Live, and Online Anytime, to meet the specific learning style of the individual and the complex learning objectives of the organization.

New Horizons Integrated Learning guides learners through all stages of the learning lifecycle. It consists of five components - AssessLearnReinforceSupport and Validate - to create the most effective learning experience available in the industry. 

Our Commitment, Guarantee and Promise