Integration Services Overview
Integration Services is a platform for building high performance data integration and workflow solutions, including extraction, transformation, and loading (ETL) operations for data warehousing.
Integration Services includes graphical tools and wizards for building and debugging packages; tasks for performing workflow functions such as FTP operations, SQL statement execution, and e-mail messaging; data sources and destinations for extracting and loading data; transformations for cleaning, aggregating, merging, and copying data; a management service, the Integration Services service, for administering Integration Services packages; and application programming interfaces (APIs) for programming the Integration Services object model.
This section provides an overview of Integration Services, including information about the typical uses of Integration Services, the Integration Services architecture, and the Integration Services tools for building and managing data integration solutions
The following table lists topics in this section.
Topic | Description |
---|---|
Describes common Integration Services usage scenarios. |
|
Describes the Integration Services architecture. |
|
Describes the tools and command prompt utilities that Integration Services includes. |
For more information about the Integration Services object model, see Integration Services Programming.
See Also
Concepts
SQL Server Integration Services
Integration Services Information Worker InfoCenter
Integration Services Administrator InfoCenter
Integration Services Developer InfoCenter
Integration Services Architect InfoCenter
Other Resources
Integration Services Objects and Concepts