如何在 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
How do I enable Integration Services (SSIS) in SQL Server 2008?
提问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?
回答by
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 2008 R2
安装程序执行的安装步骤的屏幕截图。下面列出的步骤应该让您了解安装SQL Server 2008
.
On the SQL Server installation media, right-click on Setup.exe
and 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
,单击安装,然后单击全新安装或向现有安装添加功能。
Click OKon 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 Rules
。如果安装支持规则出现警告或失败,请采取必要的措施来修复它们。
Click Installon Setup Support Files
step of SQL Server 2008 R2 Setup.
点击安装的Setup Support Files
SQL Server 2008 R2的安装步骤。
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 安装步骤中单击下一步 >Setup Support Rules
。如果安装支持规则出现警告或失败,请采取必要的措施来修复它们。
On the Installation Type
step 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 Type
SQL Server 2008 R2 安装步骤中,选择全新安装或添加共享功能或选择将功能添加到 SQL Server 2008 R2 的现有实例并选择适当的实例名称。单击下一步 >
Enter the product key on Product Key
step of SQL Server 2008 R2 Setup and click Next >
在Product Key
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.
检查I accept license terms
,如果您选择接受条款和条件,并单击下一步>上License Terms
的SQL Server 2008 R2安装步骤。
Select SQL Server Feature Installationon Setup Role
step of SQL Server 2008 R2 Setup, click Next >
在SQL Server 2008 R2 安装步骤中选择SQL Server 功能安装Setup Role
,单击下一步 >
On Feature Selection
step of SQL Server 2008 R2 Setup, you need to decide what you would like to install.
在Feature Selection
SQL 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 安装。
Read the details and click Next >on Installation Rules
step of SQL Server 2008 R2 Setup.
阅读详细信息,然后在SQL Server 2008 R2 安装步骤中单击下一步 >Installation Rules
。
Read the details and clickNext >on Disk Space Requirements
step of SQL Server 2008 R2 Setup.
阅读详细信息,然后在SQL Server 2008 R2 安装步骤中单击下一步 >Disk Space Requirements
。
Read the details and click Next >on Error Reporting
step of SQL Server 2008 R2 Setup.
阅读详细信息,然后在SQL Server 2008 R2 安装步骤中单击下一步 >Error Reporting
。
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 安装步骤中单击下一步 >Installation Configuration Rules
。如果安装配置规则出现警告或失败,请采取必要措施进行修复。
Verify the components and click Installon Ready to Install
step of SQL Server 2008 R2 Setup.
验证组件,然后单击安装在Ready to Install
SQL 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.
希望有帮助。