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