Hands-On Microsoft SQL Server™ 2005 Integration Services

Integration Services Architecture

Now you understand the benefits Integration Services provides with its vast array of features, and you also know about various versions and feature sets associated with them. Before we move further and “get our hands dirty,” let’s look more closely at the architecture; this will help you appreciate how the various components perform their jobs to execute an Integration Services package successfully. Let’s start with the architecture diagram provided in Microsoft SQL Server 2005 Books Online, shown in Figure 1-1.

Figure 1-1. Integration Services architecture

[View full size image]

Microsoft SQL Server 2005 Integration ...