Ms Sql Server 简明教程

MS SQL Server - Integration Services

此服务用于执行 ETL（提取、转换和加载数据）和管理操作。BIDS（2008 R2 之前的 Business Intelligence Studio）和 SSDT（2012 年起的 SQL Server Data Tools）是用于开发包的环境。

This service is used to carry out ETL (Extraction, Transform and Load data) and admin operations. The BIDS (Business Intelligence Studio till 2008 R2) and SSDT (SQL Server Data Tools from 2012) are the environments to develop packages.

SSIS Basic Architecture

解决方案（项目集合）--→ 项目（包集合）--→ 包（ETL 和管理操作的任务集合）

Solution (Collection of projects) --→ Project (Collection of packages) --→ Package (Collection of tasks for ETL and admin operations)

在包下，以下组件可用：

Under Package, the following components are available −

  1. Control Flow (Containers and Tasks)

  2. Data Flow (Source, Transformations, Destinations)

  3. Event Handler (Sending of messages, Emails)

  4. Package Explorer (A single view for all in package)

  5. Parameters (User interaction)

以下是打开 BIDS\SSDT 的步骤。

Following are the steps to open BIDS\SSDT.

Step 1 - 根据 Microsoft SQL Server 程序组中的版本打开 BIDS\SSDT。出现以下屏幕。

Step 1 − Open either BIDS\SSDT based on the version from the Microsoft SQL Server programs group. The following screen appears.

integration services

Step 2 - 上述屏幕显示已打开 SSDT。转到上述图像左上角的文件，然后单击“新建”。选择项目并打开以下屏幕。

Step 2 − The above screen shows SSDT has opened. Go to file at the top left corner in the above image and click New. Select project and the following screen opens.

integration services1

Step 3 - 在上述屏幕左上角的“商务智能”下选择“集成服务”以获取以下屏幕。

Step 3 − Select Integration Services under Business Intelligence on the top left corner in the above screen to get the following screen.

integration services2

Step 4 - 在上述屏幕中，根据您开发\创建包的要求，选择“集成服务项目”或“集成服务导入项目向导”。

Step 4 − In the above screen, select either Integration Services Project or Integration Services Import Project Wizard based on your requirement to develop\create the package.