Integration Services—Features and Uses

Integration Services provides a rich set of tools that are preconfigured to components and APIs that you can use to extract meaningful information from the raw data and create complex data manipulation and business applications.

Integration Services Architecture

The Integration Services architecture separates the operations-oriented workflow from the data transformation pipeline by providing two distinct engines. The Integration Services run-time engine provides run-time services such as establishing connections to various data sources, managing variables, handling transactions, debugging, logging, and event handling. The Integration Services data flow engine uses multiple data flow sources to extract data, ...

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

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.