sql-server-linux-setup-ssis.md

title	description	author	ms.author	ms.reviewer	ms.date	ms.service	ms.subservice	ms.topic	ms.custom
Install SQL Server Integration Services on Linux	This article describes how to install SQL Server Integration Services (SSIS) on Linux. You can install SSIS on Ubuntu and Red Hat Enterprise Linux.	lrtoyou1223	lle	maghan, randolphwest	11/18/2024	sql	linux	install-set-up-deploy	intro-installation linux-related-content

Install SQL Server Integration Services (SSIS) on Linux

[!INCLUDE 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:

• Release notes for SQL Server 2017 on Linux
• Release notes for SQL Server 2019 on Linux
• Release notes for SQL Server 2022 on Linux

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.

Red Hat Enterprise Linux

Install SSIS on RHEL

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

::: moniker range="=sql-server-linux-2017 || =sql-server-2017"

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 SQL Server Integration Services 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

::: moniker-end

::: moniker range="=sql-server-linux-ver15 || =sql-server-ver15"

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 SQL Server Integration Services 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

::: moniker-end

::: moniker range=">= sql-server-linux-ver16 || >= sql-server-ver16"

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 SQL Server Integration Services 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

::: moniker-end

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

SUSE Linux Enterprise Server

Install SSIS on SLES

The SQL Server Integration Services package (mssql-server-is) isn't supported on SUSE Linux Enterprise Server.

Ubuntu

Install SSIS on Ubuntu

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

::: moniker range="=sql-server-linux-2017 || =sql-server-2017"

1. Import the public repository GPG keys.

   curl https://packages.microsoft.com/keys/microsoft.asc | sudo tee /etc/apt/trusted.gpg.d/microsoft.asc

2. Register the SQL Server Ubuntu repository.

   sudo add-apt-repository "$(curl https://packages.microsoft.com/config/ubuntu/18.04/mssql-server-2017.list)"

3. Run the following commands to install SQL Server Integration Services.

   sudo apt-get update
   sudo apt-get install -y mssql-server-is

4. After installing Integration Services, run ssis-conf. For more info, see Configure SQL Server Integration Services on Linux with ssis-conf.

   sudo /opt/ssis/bin/ssis-conf setup

5. After the configuration is done, set the PATH environment variable.

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

::: moniker-end

::: moniker range="=sql-server-linux-ver15 || =sql-server-ver15"

1. Import the public repository GPG keys.

   curl https://packages.microsoft.com/keys/microsoft.asc | sudo tee /etc/apt/trusted.gpg.d/microsoft.asc

2. Register the SQL Server Ubuntu repository.

   sudo add-apt-repository "$(curl https://packages.microsoft.com/config/ubuntu/18.04/mssql-server-2019.list)"

3. Run the following commands to install SQL Server Integration Services.

   sudo apt-get update
   sudo apt-get install -y mssql-server-is

4. After installing Integration Services, run ssis-conf. For more info, see Configure SQL Server Integration Services on Linux with ssis-conf.

   sudo /opt/ssis/bin/ssis-conf setup

5. After the configuration is done, set the PATH environment variable.

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

::: moniker-end

::: moniker range=">= sql-server-linux-ver16 || >= sql-server-ver16"

1. Import the public repository GPG keys.

   curl https://packages.microsoft.com/keys/microsoft.asc | sudo tee /etc/apt/trusted.gpg.d/microsoft.asc

2. Register the SQL Server Ubuntu repository.

   sudo add-apt-repository "$(curl https://packages.microsoft.com/config/ubuntu/20.04/mssql-server-2022.list)"

3. Run the following commands to install SQL Server Integration Services.

   sudo apt-get update
   sudo apt-get install -y mssql-server-is

4. After installing Integration Services, run ssis-conf. For more info, see Configure SQL Server Integration Services on Linux with ssis-conf.

   sudo /opt/ssis/bin/ssis-conf setup

5. After the configuration is done, set the PATH environment variable.

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

::: moniker-end

Update SSIS

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

sudo apt-get install mssql-server-is

Remove SSIS

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

sudo apt-get 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.

Related content

• Extract, transform, and load data on Linux with SSIS
• Configure SQL Server Integration Services on Linux with ssis-conf
• Limitations and known issues for SSIS on Linux
• Schedule SQL Server Integration Services package execution on Linux with cron