SQL Server Integration Services – 3 days

Module 1: Introduction to SQL Server 2005 Integration Services

• Overview of Integration Services Solutions

• 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 Precedence Constraints

• Control Flow Containers

Module 4: Implementing Data Flow

• Data Flow Sources and Destinations

• Data Flow Transformations

• Data Flow Paths

Module 5: Implementing Logging

• Overview of Integration Services Logging

• Implementing 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: Deploying Packages

• Package Configurations

• Deploying Packages

Module 9: Managing and Securing Packages

• Managing Packages

• Securing Packages