安装集成服务Install Integration Services

适用范围:SQL Server,包括 Linux Azure SQL 数据库yesAzure SQL 数据仓库no并行数据仓库 APPLIES TO: yesSQL Server, including on Linux yesAzure SQL Database yesAzure SQL Data Warehouse noParallel Data Warehouse

SQL ServerSQL Server 提供了单个安装程序来安装其包括 Integration ServicesIntegration Services在内的任一组件或所有组件。provides a single Setup program to install any or all of its components, including Integration ServicesIntegration Services. 使用安装程序,可以在单台计算机上安装 Integration ServicesIntegration Services 或将其与其他 SQL ServerSQL Server 组件一起安装。Use Setup to install Integration ServicesIntegration Services with or without other SQL ServerSQL Server components on a single computer.

本文重点介绍了在安装 Integration ServicesIntegration Services 之前应了解的重要注意事项。This article highlights important considerations that you should know before you install Integration ServicesIntegration Services. 本文中的信息有助于评估安装选项,以便用户做出适当选择,使安装成功完成。Information in this article helps you evaluate the installation options so that your selections that result in a successful installation.

准备安装 Integration ServicesGet ready to install Integration Services

安装 MicrosoftMicrosoft SQL ServerSQL Server Integration ServicesIntegration Services 之前,请首先查看以下信息:Before you install MicrosoftMicrosoft SQL ServerSQL Server Integration ServicesIntegration Services, review the following information:

独立安装或并行安装Install standalone or side by side

可以按下列配置安装 SQL ServerSQL Server Integration ServicesIntegration ServicesYou can install SQL ServerSQL Server Integration ServicesIntegration Services in the following configurations:

  • 可以在没有旧 SQL ServerSQL Server 实例的计算机上安装 SQL ServerSQL Server Integration ServicesIntegration ServicesYou can install SQL ServerSQL Server Integration ServicesIntegration Services on a computer that has no previous instances of SQL ServerSQL Server.

  • 可并行安装 SQL Server 2017 Integration Services (SSIS)SQL Server 2017 Integration Services (SSIS)Integration ServicesIntegration Services 的现有实例。You can install SQL Server 2017 Integration Services (SSIS)SQL Server 2017 Integration Services (SSIS) side by side with an existing instance of Integration ServicesIntegration Services.

在已安装了 Integration ServicesIntegration Services 早期版本的计算机上升级到 Integration ServicesIntegration Services 的最新版本时,当前版本与该早期版本并行安装。When you upgrade to the latest version of Integration ServicesIntegration Services on a computer that has an earlier version of Integration ServicesIntegration Services already installed, the current version is installed side by side with the earlier version.

有关升级 Integration ServicesIntegration Services 的详细信息,请参阅升级 Integration ServicesFor more information about upgrading Integration ServicesIntegration Services, see Upgrade Integration Services.

在 SQL Server 上安装 Integration ServicesGet SQL Server with Integration Services

如果尚未安装 Microsoft SQL Server,请从 SQL Server 下载中下载免费评估版,或下载免费开发人员版。If you don't already have Microsoft SQL Server, download a free Evaluation Edition, or the free Developer Edition, from SQL Server downloads. SSIS 不包含在速成版 SQL Server 中。SSIS is not included with the Express edition of SQL Server.

安装集成服务Install Integration Services

在查看 SQL ServerSQL Server 的安装要求并确保计算机满足这些要求之后,就可以安装 Integration ServicesIntegration Services了。After you review the installation requirements for SQL ServerSQL Server and ensure that your computer meets those requirements, you are ready to install Integration ServicesIntegration Services.

如果使用安装向导安装 Integration ServicesIntegration Services,则会使用一系列页面来指定组件和选项。If you are using the Setup Wizard to install Integration ServicesIntegration Services, you use a series of pages to specify components and options.

  • 在“功能选择”页的“共享功能”下,选择“Integration Services” 。On the Feature Selection page, under Shared Features, select Integration Services.

  • 在“实例功能”下,可根据需要选择“数据库引擎服务”,以托管 SSIS 目录数据库 SSISDB,并存储、管理、运行和监视 SSIS 包 。Under Instance Features, optionally select Database Engine Services to host the SSIS Catalog database, SSISDB, to store, manage, run, and monitor SSIS packages.

  • 要安装用于 Integration ServicesIntegration Services 编程的托管程序集,仍需在“共享功能”下选中“客户端工具 SDK” 。To install managed assemblies for Integration ServicesIntegration Services programming, also under Shared Features, select Client Tools SDK.

备注

如果选择了可在安装向导的“功能选择”页上选择进行安装的某些 SQL ServerSQL Server 组件,则会安装 Integration ServicesIntegration Services 组件的部分子集 。Some SQL ServerSQL Server components that you can select for installation on the Feature Selection page of the Setup Wizard install a partial subset of Integration ServicesIntegration Services components. 这些组件可用于特定任务,但 Integration ServicesIntegration Services 的功能会受到限制。These components are useful for specific tasks, but the functionality of Integration ServicesIntegration Services is limited. 例如, “数据库引擎服务” 选项将安装 Integration ServicesIntegration Services 导入和导出向导所需的 SQL ServerSQL Server 组件。For example, the Database Engine Services option installs the Integration ServicesIntegration Services components required for the SQL ServerSQL Server Import and Export Wizard. 为确保完整安装 Integration ServicesIntegration Services,必须在 “功能选择” 页上选择“ 集成服务 ”。To ensure a complete installation of Integration ServicesIntegration Services, you must select Integration Services on the Feature Selection page.

为 ETL 进程安装专用服务器Installing a dedicated server for ETL processes

若要对提取、转换和加载 (ETL) 过程使用专用服务器,请在安装 Integration ServicesIntegration Services 时安装 SQL Server 数据库引擎SQL Server Database Engine的本地实例。To use a dedicated server for extraction, transformation, and loading (ETL) processes, install a local instance of the SQL Server 数据库引擎SQL Server Database Engine when you install Integration ServicesIntegration Services. Integration ServicesIntegration Services 通常将包存储在 数据库引擎Database Engine 实例中,并使用 SQL ServerSQL Server 代理对这些包进行计划。typically stores packages in an instance of the 数据库引擎Database Engine and relies on SQL ServerSQL Server Agent for scheduling those packages. 如果 ETL 服务器上没有 数据库引擎Database Engine实例,则必须通过具有 数据库引擎Database Engine实例的服务器计划或运行包。If the ETL server does not have an instance of the 数据库引擎Database Engine, you have to schedule or run packages from a server that does have an instance of the 数据库引擎Database Engine. 这导致这些包不会在 ETL 服务器上运行,而是在其启动时所在的服务器上运行。As a result, the packages are not running on the ETL server, but instead on the server from which they are started. 因此,专用 ETL 服务器的资源不会按预期方式使用。As a result, the resources of the dedicated ETL server are not being used as intended. 而且,其他服务器的资源可能会受到 ETL 进程运行的影响Furthermore, the resources of other servers may be strained by the running ETL processes

配置 SSIS 事件日志记录Configuring SSIS event logging

默认情况下,在全新安装中, Integration ServicesIntegration Services 配置为不将与运行包相关的事件记录到应用程序事件日志中。By default, in a new installation, Integration ServicesIntegration Services is configured not to log events that are related to the running of packages to the Application event log. 使用 SQL Server 2017SQL Server 2017的数据收集器功能时,此设置可防止生成太多事件日志项。This setting prevents too many event log entries when you use the Data Collector feature of SQL Server 2017SQL Server 2017. 未记录的事件是,EventID 12288“包已启动”和 EventID 12289“包已成功完成”。The events that are not logged are EventID 12288, "Package started," and EventID 12289, "Package finished successfully." 若要将这些事件记录到应用程序事件日志中,请打开注册表以进行编辑。To log these events to the Application event log, open the registry for editing. 然后在注册表中,找到 HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\130\SSIS 节点,并将 LogPackageExecutionToEventLog 设置的 DWORD 值从 0 更改为 1。Then, in the registry, locate the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\130\SSIS node, and change the DWORD value of the LogPackageExecutionToEventLog setting from 0 to 1.

安装 Integration Services 的其他组件Install additional components for Integration Services

要完整安装 Integration ServicesIntegration Services,请从以下列表中选择所需组件:For a complete installation of Integration ServicesIntegration Services, select the components that you need from the following list:

  • Integration Services (SSIS)Integration Services (SSIS). 使用 SQL Server 安装向导安装 SSIS。Install SSIS with the SQL Server Setup wizard. 选择 SSIS 会安装以下各项:Selecting SSIS installs the following things:

    • 对 SQL Server 数据库引擎上 SSIS 目录的支持。Support for the SSIS Catalog on the SQL Server Database Engine.

    • (可选)SSIS Scale Out 功能,包括 Master 和 Worker。Optionally, the SSIS Scale Out feature, which consists of a Master and Workers.

    • 32 位和 64 位 SSIS 组件。32-bit and 64-bit SSIS components.

    • 安装 SSIS 时不 会安装设计和开发 SSIS 包所需的工具。Installing SSIS does not install the tools required to design and develop SSIS packages.

  • SQL Server 数据库引擎SQL Server Database Engine. 使用 SQL Server 安装向导安装数据库引擎。Install the Database Engine with the SQL Server Setup wizard. 通过选择“数据库引擎”,可创建并托管 SSIS 目录数据库 SSISDB,并存储、管理、运行和监视 SSIS 包。Selecting the Database Engine lets you create and host the SSIS Catalog database, SSISDB, to store, manage, run, and monitor SSIS packages.

  • SQL Server Data Tools (SSDT)SQL Server Data Tools (SSDT). 要下载并安装 SSDT,请参阅下载 SQL Server Data Tools (SSDT)To download and install SSDT, see Download SQL Server Data Tools (SSDT). 安装 SSDT 后,可设计和部署 SSIS 包。Installing SSDT lets you design and deploy SSIS packages. SSDT 安装以下各项:SSDT installs the following things:

    • SSIS 包设计和开发工具,包括 SSIS 设计器。The SSIS package design and development tools, including SSIS Designer.

    • 仅 32 位 SSIS 组件。32-bit SSIS components only.

    • Visual Studio 的受限制版本(如果尚未安装 Visual Studio 版本)。A limited version of Visual Studio (if a Visual Studio edition is not already installed).

    • SSIS 脚本任务和脚本组件所使用的脚本编辑器 Tools for Applications (VSTA)。Visual Studio Tools for Applications (VSTA), the script editor used by the SSIS Script Task and Script Component.

    • SSIS 向导,包括部署向导和包升级向导。SSIS wizards including the Deployment Wizard and the Package Upgrade Wizard.

    • SQL Server 导入和导出向导。SQL Server Import and Export Wizard.

  • 用于 Azure 的 Integration Services 功能包Integration Services Feature Pack for Azure. 要下载并安装功能包,请参阅用于 Azure 的 Microsoft SQL Server 2017 Integration Services 功能包To download and install the Feature Pack, see Microsoft SQL Server 2017 Integration Services Feature Pack for Azure. 通过安装功能包,可将包连接到 Azure 云中的存储和分析服务,包括以下服务:Installing the Feature Pack lets your packages connect to storage and analytics services in the Azure cloud, including the following services:

    • Azure Blob 存储。Azure Blob Storage.

    • Azure HDInsight。Azure HDInsight.

    • Azure Data Lake Store。Azure Data Lake Store.

    • Azure SQL 数据仓库。Azure SQL Data Warehouse.

  • 其他可选组件Optional additional components. 根据需要,可以从 SQL Server 功能包下载其他第三方组件。You can optionally download additional third-party components from the SQL Server Feature Package.