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

Microsoft SQL Server 2005 Integration ...

Get Hands-On Microsoft SQL Server™ 2005 Integration Services now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.