Integration Services Documentation Map

Microsoft SQL Server 2005 Integration Services (SSIS) is a platform for building high-performance data integration solutions. You can build extract, transform, and load (ETL) packages to update data warehouses, interact with external processes, clean and mine data, process analytic objects, and perform administrative tasks.

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 called the Integration Services service for administering Integration Services; and application programming interfaces (APIs) for programming the Integration Services object model.

Integration Services Documentation

For more information about Integration Services, see these sections of SQL Server Books Online.

Section Description

SQL Server Integration Services

Provides an overview of the relationship between Integration Services and other SQL Server 2005 components, and includes links to role-based Integration Services InfoCenters.

Integration Services Overview

Describes typical uses of Integration Services, provides an overview of the Integration Services architecture and tools.

Installing SQL Server Integration Services

Describes how to install Integration Services by using Setup or from the command prompt.

Integration Services Objects and Concepts

Discusses the objects that Integration Services provides for constructing robust control flow and data flow in packages. Introduces the more advanced objects that make packages more flexible and easier to manage and troubleshoot.

Integration Services in Business Intelligence Development Studio

Describes the Business Intelligence Development Studio environment that you will use to develop Integration Services packages for data extraction, transformation, and loading (ETL).

Building Solutions and Integration Services Projects

Introduces solutions and projects. Describes how you use the Integration Services project to manage objects in an ETL solution.

Designing and Creating Integration Services Packages

Provides walkthroughs for common tasks, basic as well as advanced, that you perform in the development of an ETL solution.

Integration Services Tutorials

Provides tutorials that teach you how to create a basic package by using the SQL Server Import and Export Wizard, create a more complex package from scratch, and deploy packages to a target server

SQL Server Integration Services Samples

Includes the topics that describe the Integration Services samples. The samples are ready-to run packages or sample code for custom tasks, data flow components, log providers, and connection managers.

Integration Services Programming

Provides conceptual programming information, lots of sample code, and documents the Integration Services API.

Integration Services Expression Reference

Discusses the new Integration Services expression language and provides documentation of the operators and functions in the language.

Deploying Integration Services Packages

Provides information about configurations and how you implement them in packages, how you build the deployment utility, and the steps to install packages on a target computer.

Security Considerations for Integration Services

Describes the security-related properties that you can set on packages and the fixed database-level roles for controlling access to packages.

Administering Integration Services

Provides information about Integration Services service and how to use it to manage packages, how to run packages on demand or schedule, and how to load balance by running packages on remote servers.

Troubleshooting Integration Services

Provides information about troubleshooting Integration Services by using the features and tools that Business Intelligence Development Studio provides as well as information about designing, monitoring performance in packages, and managing the Integration Services service.

Using Integration Services with Other SQL Server Features

Explores the relationship between Integration Services and other SQL Server 2005 components, including detailed information about Integration Services objects that are tailored for use with specific components.

Integration Services How-to Topics

Provides step-by-step instructions for accomplishing tasks in Integration Services.

Integration Services F1 Help

Provides detailed information about the options on every page and dialog box in Integration Services. These topics can also be displayed by pressing the F1 key or the Help button while working with the Integration Services tools.

International Considerations for Integration Services

Discusses Integration Services features that support the parsing and manipulation of multilingual data and the special comparison options for sorting and comparing international string data.

dtexec Utility

Contains reference information for the dtexec command prompt utility.

dtutil Utility

Contains reference information for the dtutil command prompt utility.

Another avenue into the documentation is via SQL Server Integration Services (How Do I), which provides links to common tasks and frequently-accessed conceptual information.

See Also


SQL Server Overview

Other Resources

SQL Server 2005 Books Online

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release History

14 April 2006

Changed content:
  • Topic rewritten to include links to high-level topics in the Integration Services documentation