Course: MS2792 Implementing and Maintaining Microsoft SQL Server 2005 Integration Services

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.

The course consists of 9 Modules:

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

By the end of the course, delegates should 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.