Home > Courses Certifications > Data Management > Course 6235 synopsis

6235 - Implementing and Maintaining Microsoft SQL Server 2008 Integration Services

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

Duration: 3 days

 

Module 1: Introduction to SQL Server 2008 Integration Services

• Overview of SQL Server Integration Services
• Using Integration Services Tools

Module 2: Developing Integration Services Solutions

• Creating an Integration Services Solution
• Using Variables
• Building and Running a Solution

Module 3: Implementing Control Flow

• Control Flow Tasks
• Control Flow Precedent Constraints
• Control Flow Containers

Module 4: Implementing Data Flow

• Data Flow Sources and Destinations
• Basic Data Flow Transformations
• Advanced Data Flow Transformations
• Data Flow Paths

Module 5: Implementing Logging

• Overview of Integration Services Logging
• Enabling and Configuring Logging

Module 6: Debugging and Error Handling

• Debugging a Package
• Implementing Error Handling

Module 7: Implementing Checkpoints and Transactions

• Implementing Checkpoints
• Implementing Transactions

Module 8: Configuring and Deploying Packages

• Package Configurations
• Deploying Packages

Module 9: Managing and Securing Packages

• Managing Packages
• Securing Packages