Overview (Integration Services)

SQL Server 2008 Books Online (October 2009)

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

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.

Stay Up to Date with Integration Services

For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN or TechNet:

For automatic notification of these updates, subscribe to the RSS feeds available on the page.

Concepts

Other Resources

Help and Information