Overview (Integration Services)

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

In This Section

• SSIS Package Essentials
  Describes the basic components of a package.

• Tools and Utilities Overview (Integration Services)
  Describes the tools and command prompt utilities that Integration Services includes.

Related Sections

• Typical Uses of Integration Services
  Describes common Integration Services usage scenarios.

• Integration Services Architect InfoCenter
  Describes the Integration Services architecture.

• Developer's Guide (Integration Services)
  Describes the the Integration Services object model.

See Also

Concepts