Transmenu powered by JoomlArt.com - Mambo Joomla Professional Templates Club

Course Length: 3 days.   

Overview

This course provides students with the knowledge to implement an Integration Services solution in their organisations. In addition students will be able to develop, deploy and manage Integration Services packages.

Students will learn how to describe and create SQL Server Integration Services packages and its tools. They will also be able to implement logging, data flow and control flow in an Integration Services package. Furthermore, students will be capable of debugging and implementing error handling and checkpoints and transactions in an Integration Services package. Finally, students can deploy, manage and secure an Integration Services package.

Audience

This course is intended for Information Technology Professionals and Developers who need to implement data transfers or extract, transform and load (ETL) solutions by using Microsoft SQL Server 2005 Integration Services.

Outline

1. Introducing and Implementing SQL Server 2005 Integration Services
2. Developing Integration Services Solutions
3. Implementing Control Flow
4. Implementing Data Flow
5. Implementing Logging
6. Debugging and Error Handling
7. Implementing Checkpoints and Transactions
8. Deploying Packages
9. Managing and Securing Packages

Prerequisites

Students must have exposure to enterprise data import and export scenarios and experience navigating the Microsoft Windows Server environment. In addition, students should have experience with Microsoft SQL server including SQL server Agent, server query language, server system tables and server accounts.