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

Typical Uses of Integration Services

Describes common Integration Services usage scenarios.

Integration Services Architecture

Describes the Integration Services architecture.

Integration Services Tools and Utilities

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

Help and Information

Getting SQL Server 2005 Assistance