Breyta

Deila með


Install SQL Server Integration Services (SSIS) on Linux

Applies to: SQL Server - Linux

Follow the steps in this article to install SQL Server Integration Services (mssql-server-is) on Linux. For more information about the features that are supported in Integration Services for Linux, see:

You can install SQL Server Integration Services (SSIS) on Red Hat Enterprise Linux (RHEL) and Ubuntu. SUSE Linux Enterprise Server (SLES) isn't supported. Installing SSIS on containers is also not supported.

Install SSIS on RHEL

To install the mssql-server-is package on RHEL, follow these steps:

  1. 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. Run the following command to install SQL Server Integration Services.

    sudo yum install -y mssql-server-is
    
  3. After installation, run ssis-conf. For more info, see Configure SSIS on Linux with ssis-conf.

    sudo /opt/ssis/bin/ssis-conf setup
    
  4. After the configuration is done, set the PATH environment variable.

    export PATH=/opt/ssis/bin:$PATH
    
  1. 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/8/mssql-server-2019.repo
    
  2. Run the following command to install SQL Server Integration Services.

    sudo yum install -y mssql-server-is
    
  3. After installation, run ssis-conf. For more info, see Configure SSIS on Linux with ssis-conf.

    sudo /opt/ssis/bin/ssis-conf setup
    
  4. After the configuration is done, set the PATH environment variable.

    export PATH=/opt/ssis/bin:$PATH
    
  1. 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/8/mssql-server-2022.repo
    
  2. Run the following command to install SQL Server Integration Services.

    sudo yum install -y mssql-server-is
    
  3. After installation, run ssis-conf. For more info, see Configure SSIS on Linux with ssis-conf.

    sudo /opt/ssis/bin/ssis-conf setup
    
  4. After the configuration is done, set the PATH environment variable.

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

Update SSIS

If you already have mssql-server-is installed, update to the latest version by using the following command:

sudo yum update mssql-server-is

Remove SSIS

To remove mssql-server-is, run the following command:

sudo yum remove mssql-server-is

Unattended setup

To run ssis-conf setup unattended (RHEL and Ubuntu only), do the following steps:

  1. Specify the -n (no prompt) option.
  2. Provide required values by setting environment variables.

The following example does these actions:

  • Installs SSIS
  • Specifies the Developer edition by providing a value for the SSIS_PID environment variable
  • Accepts the Microsoft Software License Terms by providing a value for the ACCEPT_EULA environment variable
  • Runs an unattended setup 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 setup

Environment variable Description
ACCEPT_EULA Accepts the SQL Server license terms when set to any value like Y.
SSIS_PID Sets the SQL Server edition or product key. Here are the possible values:

- Evaluation
- Developer
- Express
- Web
- Standard
- Enterprise
- A product key

If you specify a product key, it must be in the form #####-#####-#####-#####-#####, where # is a letter or a digit.