SQL Server 2005 Integration Services 介绍

SQL Server 2005 Intefration Services（简称SSIS）是用于创建高性能的数据集成解决方案的平台，它能够执行析取(extraction)，转换(transformation)和加载(load),缩写为ETL。用于为数据仓库提供服务。

Integration Services包括

1. 图形工具和创建及程序包Debug精灵(Wizard)；
2. 在工作流模式下执行的任务项，如FTP操作，执行SQL 命令，或者发送电子邮件；
3. 用于析取和加载数据的数据源和数据目的地；
4. 用于清理(cleaning)、聚合(aggregating)、合并(merging、复制(copying)数据的转换。
5. 用于管理集成服务(Integration Services)的windows service Integration Services service。
6. 提供了应用程序接口用于开发集成服务的对象模式(object model).

集成服务是数据转换服务(Data Transformation Services，简称DTS)的替代者，后者DTS是自SQL Server 7.0引入的技术。

原文如下：

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.

 

为了MVP开始更新CSDN的Blog,虽然我一直希望能够在自己的网站恢复上线后(www.csharpproject.com)，把这些文章放到自己的网站上，但是现在看来，现在如果不打算开始写，就太晚了。

 

数据挖掘是我最近才涉足的领域，所以不敢写原创的文章，怕误导阅读者，主要将以转贴和翻译为主。