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:
- 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.
Install SSIS on RHEL
To install the mssql-server-is package on RHEL, follow these steps:
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
Run the following command to install SQL Server Integration Services.
sudo yum install -y mssql-server-is
After installation, run ssis-conf. For more info, see Configure SSIS on Linux with ssis-conf.
sudo /opt/ssis/bin/ssis-conf setup
After the configuration is done, set the
PATH
environment variable.export PATH=/opt/ssis/bin:$PATH
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
Run the following command to install SQL Server Integration Services.
sudo yum install -y mssql-server-is
After installation, run ssis-conf. For more info, see Configure SSIS on Linux with ssis-conf.
sudo /opt/ssis/bin/ssis-conf setup
After the configuration is done, set the
PATH
environment variable.export PATH=/opt/ssis/bin:$PATH
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
Run the following command to install SQL Server Integration Services.
sudo yum install -y mssql-server-is
After installation, run ssis-conf. For more info, see Configure SSIS on Linux with ssis-conf.
sudo /opt/ssis/bin/ssis-conf setup
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:
- Specify the
-n
(no prompt) option. - 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. |