如何在 SQL Server 2008 中启用集成服务 (SSIS)? [英] How do I enable Integration Services (SSIS) in SQL Server 2008?

问题描述

我无法在 SQL Server 2008 中启动 SSIS.这是 SQL Server 安装程序的屏幕截图.我应该从哪里开始在 SQL Server 2008 中启用/安装 Integration Services?

I cannot start SSIS in SQL Server 2008. Here is a screenshot of SQL Server installer. Where should I begin to enable/install Integration Services in SQL Server 2008?

推荐答案

以下是使用 SQL Server 2008 R2 安装程序执行的安装步骤的屏幕截图.下面列出的步骤应该让您了解安装 SQL Server 2008 的必要组件.

Here are the screenshots of installation steps taken using SQL Server 2008 R2 installer. The steps listed below should give you an idea to install necessary components of SQL Server 2008.

在 SQL Server 安装媒体上，右键单击 Setup.exe 并选择以管理员身份运行.

On the SQL Server installation media, right-click on Setup.exe and select Run as administrator.

在SQL Server 安装中心，单击安装，然后单击全新安装或向现有安装添加功能.

在 SQL Server 2008 R2 安装程序的 Setup Support Rules 步骤中单击 OK.如果安装支持规则出现警告或失败，请采取必要措施进行修复.

Click OK on Setup Support Rules step of SQL Server 2008 R2 Setup. If there are warnings or failures on Setup Support Rules, take necessary actions to fix them.

在 SQL Server 2008 R2 安装程序的 Setup Support Files 步骤中单击 Install.

Click Install on Setup Support Files step of SQL Server 2008 R2 Setup.

在 SQL Server 2008 R2 安装程序的 Setup Support Rules 步骤中单击 Next >.如果安装支持规则出现警告或失败，请采取必要措施进行修复.

Click Next > on Setup Support Rules step of SQL Server 2008 R2 Setup. If there are warnings or failures on Setup Support Rules, take necessary actions to fix them.

在 SQL Server 2008 R2 安装程序的 Installation Type 步骤中，选择 全新安装或添加共享功能 或选择 向现有 SQL 实例添加功能Server 2008 R2 并选择合适的实例名称.点击下一步>

On the Installation Type step of SQL Server 2008 R2 Setup, select either New installation or add shared features or select Add features to an existing instance of SQL Server 2008 R2 and pick an appropriate instance name. Click Next >

在 SQL Server 2008 R2 安装程序的 Product Key 步骤中输入产品密钥，然后单击 下一步 >

Enter the product key on Product Key step of SQL Server 2008 R2 Setup and click Next >

勾选我接受许可条款，如果你选择接受条款和条件，在SQL Server的许可条款步骤点击下一步>2008 R2 设置.

Check I accept license terms, if you choose to accept the terms and conditions and click Next > on License Terms step of SQL Server 2008 R2 Setup.

在SQL Server 2008 R2安装的Setup Role步骤中选择SQL Server Feature Installation，点击下一步>

Select SQL Server Feature Installation on Setup Role step of SQL Server 2008 R2 Setup, click Next >

在 SQL Server 2008 R2 安装程序的 Feature Selection 步骤中，您需要决定要安装的内容.

On Feature Selection step of SQL Server 2008 R2 Setup, you need to decide what you would like to install.

• 如果您只需要用于 SSIS 包开发的 Business Intelligence Development Studio，则只需安装 Business Intelligence Development Studio.

• If you need only the Business Intelligence Development Studio for SSIS packages development, then install only the Business Intelligence Development Studio.

如果您需要集成服务来部署和运行 SSIS 包，请选择集成服务.注意:我建议您在选择此选项之前阅读 MSDN 或 Microsoft 网站上的许可要求.

If you need the Integration Services to deploy and run the SSIS packages, choose Integration Services. NOTE: I would recommend reading Licensing requirements on MSDN or Microsoft website before you choose this option.

下面的屏幕截图显示了 SSIS 包开发和其他仅客户端组件的 BIDS 安装.

Below screenshot shows BIDS installation for SSIS packages development and other client only components.

阅读详细信息，然后在 SQL Server 2008 R2 安装程序的 Installation Rules 步骤中单击 Next >.

Read the details and click Next > on Installation Rules step of SQL Server 2008 R2 Setup.

阅读详细信息，然后在 SQL Server 2008 R2 安装程序的磁盘空间要求步骤中单击下一步>.

Read the details and clickNext > on Disk Space Requirements step of SQL Server 2008 R2 Setup.

阅读详细信息，然后在 SQL Server 2008 R2 安装程序的 Error Reporting 步骤中单击 Next >.

Read the details and click Next > on Error Reporting step of SQL Server 2008 R2 Setup.

在 SQL Server 2008 R2 安装程序的 Installation Configuration Rules 步骤中单击 Next >.如果安装配置规则出现警告或失败，请采取必要措施进行修复.

Click Next > on Installation Configuration Rules step of SQL Server 2008 R2 Setup. If there are warnings or failures on Installation Configuration Rules, take necessary actions to fix them.

验证组件并在 SQL Server 2008 R2 安装程序的 Ready to Install 步骤中单击 Install.

Verify the components and click Install on Ready to Install step of SQL Server 2008 R2 Setup.

安装完成后，将出现状态向导.如果一切顺利，请单击关闭；如果安装失败，请采取必要措施.

Once the install is complete, the status wizard will appear. Click Close if everything is successful else take necessary action if the install fails.

希望有所帮助.

这篇关于如何在 SQL Server 2008 中启用集成服务 (SSIS)?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！