SQL Server Integration Services

Microsoft SQL Server 2005 Integration Services (SSIS) is a platform for building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.

Integration Services includes graphical tools and wizards for building and debugging packages; tasks for performing workflow functions such as FTP operations, for executing SQL statements, or for sending e-mail messages; 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; and application programming interfaces (APIs) for programming the Integration Services object model.

Integration Services replaces Data Transformation Services (DTS), which was first introduced as a component of SQL Server 7.0.

Integration Services Overview An introduction to the Integration Services features and architecture.

Integration Services Information Worker InfoCenter Provides information for package designers who build data transformation solutions using the graphical tools that Integration Services provides.

Integration Services Administrator InfoCenter Focuses on quickly getting the database administrator familiar with the installation and maintenance of Integration Services packages.

Integration Services Developer InfoCenter Provides an overview of the technologies and languages needed to implement an embedded data transformation solution.

Integration Services Architect InfoCenter Gives a broad view of the data transformation domain and describes how Integration Services can be effectively used in business intelligence solutions.