如何在 SQL Server 2008 中启用集成服务 (SSIS)?

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/14551255/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-01 13:19:00  来源:igfitidea点击:

How do I enable Integration Services (SSIS) in SQL Server 2008?

sqlsql-server-2008ssisinstallation

提问by user961627

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 中启动 SSIS。这是 SQL Server 安装程序的屏幕截图。我应该从哪里开始在 SQL Server 2008 中启用/安装 Integration Services?

enter image description here

在此处输入图片说明

回答by

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

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

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

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

On SQL Server Installation Center, click Installationand then click New installation or add features to an existing installation.

在上SQL Server Installation Center,单击安装,然后单击全新安装或向现有安装添加功能

Installer

安装程序

Click OKon Setup Support Rulesstep 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 Rules。如果安装支持规则出现警告或失败,请采取必要的措施来修复它们。

Click Installon Setup Support Filesstep of SQL Server 2008 R2 Setup.

点击安装Setup Support FilesSQL Server 2008 R2的安装步骤。

Click Next >on Setup Support Rulesstep 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 Rules。如果安装支持规则出现警告或失败,请采取必要的措施来修复它们。

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

Installation TypeSQL Server 2008 R2 安装步骤中,选择全新安装或添加共享功能或选择将功能添加到 SQL Server 2008 R2 的现有实例并选择适当的实例名称。单击下一步 >

Installation type

安装类型

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

Product KeySQL Server 2008 R2 安装步骤中输入产品密钥,然后单击下一步 >

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

检查I accept license terms,如果您选择接受条款和条件,并单击下一步>License Terms的SQL Server 2008 R2安装步骤。

Select SQL Server Feature Installationon Setup Rolestep of SQL Server 2008 R2 Setup, click Next >

在SQL Server 2008 R2 安装步骤中选择SQL Server 功能安装Setup Role,单击下一步 >

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

Feature SelectionSQL Server 2008 R2 安装步骤中,您需要决定要安装的内容。

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

  • 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 包开发的 Business Intelligence Development Studio,则只需安装 Business Intelligence Development Studio。

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

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

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

Feature Selection

特征选择

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

阅读详细信息,然后在SQL Server 2008 R2 安装步骤中单击下一步 >Installation Rules

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

阅读详细信息,然后在SQL Server 2008 R2 安装步骤中单击下一步 >Disk Space Requirements

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

阅读详细信息,然后在SQL Server 2008 R2 安装步骤中单击下一步 >Error Reporting

Click Next >on Installation Configuration Rulesstep 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 安装步骤中单击下一步 >Installation Configuration Rules。如果安装配置规则出现警告或失败,请采取必要措施进行修复。

Verify the components and click Installon Ready to Installstep of SQL Server 2008 R2 Setup.

验证组件,然后单击安装Ready to InstallSQL Server 2008 R2的安装步骤。

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

安装完成后,将出现状态向导。如果一切顺利,请单击关闭,否则如果安装失败则采取必要的措施。

Hope that helps.

希望有帮助。