在 Linux 上安装 SQL Server Integration Services (SSIS)Install SQL Server Integration Services (SSIS) on Linux

适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) - Linux适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) - Linux

按照本文中的步骤在 Linux 上安装 SQL Server Integration Services (mssql-server-is )。Follow the steps in this article to install SQL Server Integration Services (mssql-server-is) on Linux. 有关此版 Integration Services for Linux 支持的功能的信息,请参阅发行说明For info about the features that are supported in this release of Integration Services for Linux, see the Release Notes.

可以在以下平台上安装 SQL Server Integration Services:You can install SQL Server Integration Services on these platforms:

在 Ubuntu 上安装 SSISInstall SSIS on Ubuntu

要在 Ubuntu 上安装 mssql-server-is 包,请按照以下步骤操作 :To install the mssql-server-is package on Ubuntu, follow these steps:

  1. 导入公共存储库 GPG 密钥。Import the public repository GPG keys.

    curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
    
  2. 注册 SQL Server Ubuntu 存储库。Register the SQL Server Ubuntu repository.

    sudo add-apt-repository "$(curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server-2017.list)"
    
  3. 运行以下命令,安装 SQL Server Integration Services。Run the following commands to install SQL Server Integration Services.

    sudo apt-get update
    sudo apt-get install -y mssql-server-is
    
  4. 安装 Integration Services 后,运行 ssis-conf 。After installing Integration Services, run ssis-conf. 有关详细信息,请参阅使用 ssis-conf 在 Linux 上配置 SSISFor more info, see Configure SSIS on Linux with ssis-conf.

    sudo /opt/ssis/bin/ssis-conf setup
    
  5. 完成配置后,设置 PATH 环境变量。After the configuration is done, set the PATH environment variable.

    export PATH=/opt/ssis/bin:$PATH
    
  1. 导入公共存储库 GPG 密钥。Import the public repository GPG keys.

    curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
    
  2. 注册 SQL Server Ubuntu 存储库。Register the SQL Server Ubuntu repository.

    sudo add-apt-repository "$(curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server-2019.list)"
    
  3. 运行以下命令,安装 SQL Server Integration Services。Run the following commands to install SQL Server Integration Services.

    sudo apt-get update
    sudo apt-get install -y mssql-server-is
    
  4. 安装 Integration Services 后,运行 ssis-conf 。After installing Integration Services, run ssis-conf. 有关详细信息,请参阅使用 ssis-conf 在 Linux 上配置 SSISFor more info, see Configure SSIS on Linux with ssis-conf.

    sudo /opt/ssis/bin/ssis-conf setup
    
  5. 完成配置后,设置 PATH 环境变量。After the configuration is done, set the PATH environment variable.

    export PATH=/opt/ssis/bin:$PATH
    

更新 SSISUpdate SSIS

如果已安装 mssql-server-fts,可使用下列命令将其更新至最新版本 :If you already have mssql-server-is installed, update to the latest version with the following command:

sudo apt-get install mssql-server-is

删除 SSISRemove SSIS

要删除 mssql-server-is,请运行以下命令 :To remove mssql-server-is, run the following command:

sudo apt-get remove mssql-server-is

在 RHEL 上安装 SSISInstall SSIS on RHEL

要在 RHEL 上安装 mssql-server-is 包,请按照以下步骤操作 :To install the mssql-server-is package on RHEL, follow these steps:

  1. 下载 SQL Server Red Hat 存储库配置文件。Download the SQL Server Red Hat repository configuration file.

    sudo curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/7/mssql-server-2017.repo
    
  2. 运行以下命令,安装 SQL Server Integration Services。Run the following command to install SQL Server Integration Services.

    sudo yum install -y mssql-server-is
    
  3. 安装后,运行 ssis-conf 。After installation, run ssis-conf. 有关详细信息,请参阅使用 ssis-conf 在 Linux 上配置 SSISFor more info, see Configure SSIS on Linux with ssis-conf.

    sudo /opt/ssis/bin/ssis-conf setup
    
  4. 完成配置后,设置 PATH 环境变量。After the configuration is done, set the PATH environment variable.

    export PATH=/opt/ssis/bin:$PATH
    
  1. 下载 SQL Server Red Hat 存储库配置文件。Download the SQL Server Red Hat repository configuration file.

    sudo curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/7/mssql-server-2019.repo
    
  2. 运行以下命令,安装 SQL Server Integration Services。Run the following command to install SQL Server Integration Services.

    sudo yum install -y mssql-server-is
    
  3. 安装后,运行 ssis-conf 。After installation, run ssis-conf. 有关详细信息,请参阅使用 ssis-conf 在 Linux 上配置 SSISFor more info, see Configure SSIS on Linux with ssis-conf.

    sudo /opt/ssis/bin/ssis-conf setup
    
  4. 完成配置后,设置 PATH 环境变量。After the configuration is done, set the PATH environment variable.

    export PATH=/opt/ssis/bin:$PATH
    

更新 SSISUpdate SSIS

如果已安装 mssql-server-fts,可使用下列命令将其更新至最新版本 :If you already have mssql-server-is installed, update to the latest version by using the following command:

sudo yum update mssql-server-is

删除 SSISRemove SSIS

要删除 mssql-server-is,请运行以下命令 :To remove mssql-server-is, run the following command:

sudo yum remove mssql-server-is

无人参与的安装Unattended installation

要将 ssis-conf setup 作为无人参与的安装运行,请执行以下步骤 :To run ssis-conf setup as an unattended installation, do the following steps:

  1. 指定 -n(无提示)选项 。Specify the -n (no prompt) option.
  2. 通过设置环境变量来提供所需的值。Provide required values by setting environment variables.

下面的示例执行以下操作:The following example does these actions:

  • 安装 SSISInstalls SSIS
  • 通过为 SSIS_PID 环境变量提供值来指定开发人员版本Specifies the Developer edition by providing a value for the SSIS_PID environment variable
  • 通过提供 ACCEPT_EULA 环境变量的值来接受 Microsoft 软件许可条款Accepts the Microsoft Software License Terms by providing a value for the ACCEPT_EULA environment variable
  • 通过指定 -n(无提示)选项来运行无人参与安装 Runs an unattended installation by specifying the -n (no prompt) option
sudo SSIS_PID=Developer ACCEPT_EULA=Y /opt/ssis/bin/ssis-conf -n setup 

无人参与安装的环境变量Environment variables for unattended installation

环境变量Environment variable 说明Description
ACCEPT_EULAACCEPT_EULA 设置为任何值(例如“Y”)时,都接受 SQL Server 许可条款。Accepts the SQL Server license terms when set to any value like "Y".
SSIS_PIDSSIS_PID 设置 SQL Server 版本或产品密钥。Sets the SQL Server edition or product key. 可能的值有:Here are the possible values:
  • 计算Evaluation
  • 开发人员Developer
  • ExpressExpress
  • WebWeb
  • StandardStandard
  • EnterpriseEnterprise
  • 产品密钥A product key
指定产品密钥时,其格式必须为:#####-#####-#####-#####-#####,其中 # 为字母或数字。If you specify a product key, it must be in the form #####-#####-#####-#####-#####, where # is a letter or a digit.

后续步骤Next steps

若要在 Linux 上运行 SSIS 包,请参阅使用 SSIS 在 Linux 上提取、转换和加载用于 SQL Server 的数据To run SSIS packages on Linux, see Extract, transform, and load data for SQL Server on Linux with SSIS.

若要在 linux 上配置其他 SSIS 设置,请参阅使用 ssis-conf 在 linux 上配置 SQL Server Integration ServicesTo configure additional SSIS settings on Linux, see Configure SQL Server Integration Services on Linux with ssis-conf.