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