Click to Rate and Give Feedback
SQL Server 2005 Books Online (September 2007)
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 icon Integration Services Overview An introduction to the Integration Services features and architecture.

Information worker icon

Integration Services Information Worker InfoCenter

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

Administrator icon

Integration Services Administrator InfoCenter

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

Developer icon

Integration Services Developer InfoCenter

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

Database architect icon

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.

Component interfaces with Integration Services

Tags What's this?: mark (x) Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
Processing
© 2008 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Page view tracker