| title | Install SQL Server Integration Services on Linux | Microsoft Docs |
|---|---|
| description | This article describes how to install SQL Server Integration Services (SSIS) on Linux. |
| author | leolimsft |
| ms.author | lle |
| ms.reviewer | douglasl |
| manager | craigg |
| ms.date | 01/09/2018 |
| ms.topic | article |
| ms.prod | sql-non-specified |
| ms.prod_service | database-engine |
| ms.service | |
| ms.component | |
| ms.suite | sql |
| ms.custom | sql-linux |
| ms.technology | database-engine |
| ms.workload | On Demand |
[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md-linuxonly]
Follow the steps in this article to install SQL Server Integration Services (mssql-server-is) on Linux. For info about the features supported in this release of Integration Services for Linux, see the Release Notes.
Install SQL Server Integration Servers for your platform:
To install the mssql-server-is package on Ubuntu, follow these steps:
-
Import the public repository GPG keys.
curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add - -
Register the Microsoft SQL Server Ubuntu repository.
sudo add-apt-repository "$(curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server-2017.list)" -
Run the following commands to install SQL Server Integration Services.
sudo apt-get update sudo apt-get install -y mssql-server-is
-
After installing Integration Services, 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.
export PATH=/opt/ssis/bin:$PATH
If you already have mssql-server-is installed, you can update to the latest version with the following command:
sudo apt-get install mssql-server-isTo remove mssql-server-is, you can run following command:
sudo apt-get remove mssql-server-isTo install the mssql-server-is package on RHEL, follow these steps:
-
Download the Microsoft 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 commands 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
-
Once the configuration is done, set path.
export PATH=/opt/ssis/bin:$PATH
If you already have mssql-server-is installed, you can update to the latest version with the following command:
sudo yum update mssql-server-isTo remove mssql-server-is, you can run following command:
sudo yum remove mssql-server-isTo run an unattended installation when you run ssis-conf setup, do the following things:
- Specify the
-n(no prompt) option. - Provide required values by setting environment variables.
The following example does the following things:
- Installs SSIS.
- Specifies the Developer edition by providing a value for the
SSIS_PIDenvironment variable. - Accepts the EULA by providing a value for the
ACCEPT_EULAenvironment variable. - 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 variable | Description |
|---|---|
| ACCEPT_EULA | Accepts the SQL Server license agreement when set to any value (for example, 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, the product key must be in the form #####-#####-#####-#####-#####, where # is a letter or a number. |
To run SSIS packages on Linux, see Extract, transform, and load data for SQL Server on Linux with SSIS.
To configure additional SSIS settings on Linux, see Configure SQL Server Integration Services on Linux with ssis-conf.