Permalink
December 28, 2022 16:04
June 14, 2017 10:35
January 25, 2023 13:39
December 28, 2022 16:04
January 17, 2023 10:58
December 28, 2022 16:04
June 14, 2017 10:35
January 9, 2020 14:38
December 28, 2022 16:04
December 28, 2022 16:04
December 28, 2022 16:04
December 28, 2022 16:04
June 14, 2017 10:35
June 14, 2017 10:35
December 28, 2022 16:04
December 28, 2022 16:04
December 28, 2022 16:04
December 18, 2019 10:37
January 25, 2023 13:39
December 28, 2022 16:04
December 28, 2022 16:04
December 28, 2022 16:04
December 28, 2022 16:04
January 25, 2023 13:39
January 25, 2023 13:39
December 28, 2022 16:04
January 25, 2023 13:39
January 25, 2023 13:39
December 28, 2022 16:04
December 28, 2022 16:04
June 14, 2017 10:35
December 28, 2022 16:04
January 9, 2020 14:38
December 28, 2022 16:04
December 28, 2022 16:04
December 28, 2022 16:04
January 9, 2020 14:38
Newer
100644
257 lines (169 sloc)
7.69 KB
3
description: This article describes how to install SQL Server Integration Services (SSIS) on Linux. You can install SSIS on Ubuntu and Red Hat Enterprise Linux.
14
17
Follow the steps in this article to install SQL Server Integration Services (**mssql-server-is**) for [!INCLUDE [sssql17-md](../includes/sssql17-md.md)] and [!INCLUDE [sssql19-md](../includes/sssql19-md.md)] on Linux. For more information about the features that are supported in Integration Services for Linux, see:
19
- [Release notes for SQL Server 2017 on Linux](sql-server-linux-release-notes-2017.md)
20
- [Release notes for SQL Server 2019 on Linux](sql-server-linux-release-notes-2019.md)
22
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.
26
## <a id="RHEL"></a> Install SSIS on RHEL
27
28
To install the **mssql-server-is** package on RHEL, follow these steps:
29
30
<!--SQL Server 2017 on Linux-->
31
::: moniker range="= sql-server-linux-2017 || = sql-server-2017"
32
36
sudo curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/7/mssql-server-2017.repo
45
1. After installation, run **ssis-conf**. For more info, see [Configure SSIS on Linux with ssis-conf](sql-server-linux-configure-ssis.md).
65
sudo curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/8/mssql-server-2019.repo
74
1. After installation, run **ssis-conf**. For more info, see [Configure SSIS on Linux with ssis-conf](sql-server-linux-configure-ssis.md).
75
79
80
1. After the configuration is done, set the `PATH` environment variable.
81
82
```bash
83
export PATH=/opt/ssis/bin:$PATH
84
```
85
86
::: moniker-end
87
90
If you already have **mssql-server-is** installed, update to the latest version by using the following command:
104
# [SUSE Linux Enterprise Server](#tab/sles)
105
106
## <a id="SLES"></a> Install SSIS on SLES
107
108
The SQL Server Integration Services package (**mssql-server-is**) is not supported on SUSE Linux Enterprise Server.
109
110
# [Ubuntu](#tab/ubuntu)
111
112
## <a id="ubuntu"></a> Install SSIS on Ubuntu
113
114
<!--SQL Server 2017 on Linux-->
115
::: moniker range="= sql-server-linux-2017 || = sql-server-2017"
117
To install the **mssql-server-is** package on Ubuntu, follow these steps:
118
122
curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
128
sudo add-apt-repository "$(curl https://packages.microsoft.com/config/ubuntu/18.04/mssql-server-2017.list)"
131
1. Run the following commands to install SQL Server Integration Services.
132
133
```bash
134
sudo apt-get update
135
sudo apt-get install -y mssql-server-is
136
```
137
138
1. After installing Integration Services, run **ssis-conf**. For more info, see [Configure SSIS on Linux with ssis-conf](sql-server-linux-configure-ssis.md).
144
1. After the configuration is done, set the `PATH` environment variable.
152
If you already have **mssql-server-is** installed, update to the latest version with the following command:
168
<!--SQL Server 2019 on Linux-->
169
::: moniker range=">= sql-server-linux-ver15 || >= sql-server-ver15"
170
171
To install the **mssql-server-is** package on Ubuntu, follow these steps:
172
173
1. Import the public repository GPG keys.
174
175
```bash
176
curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
177
```
178
179
1. Register the SQL Server Ubuntu repository.
180
181
```bash
182
sudo add-apt-repository "$(curl https://packages.microsoft.com/config/ubuntu/18.04/mssql-server-2019.list)"
185
> [!NOTE]
186
> The SQL Server Integration Services package (**mssql-server-is**) is not supported on Ubuntu 20.04.
187
188
1. Run the following commands to install SQL Server Integration Services.
189
190
```bash
191
sudo apt-get update
192
sudo apt-get install -y mssql-server-is
193
```
194
195
1. After installing Integration Services, run **ssis-conf**. For more info, see [Configure SSIS on Linux with ssis-conf](sql-server-linux-configure-ssis.md).
196
197
```bash
198
sudo /opt/ssis/bin/ssis-conf setup
199
```
200
201
1. After the configuration is done, set the `PATH` environment variable.
209
If you already have **mssql-server-is** installed, update to the latest version with the following command:
210
229
To run **ssis-conf setup** unattended (RHEL and Ubuntu only), do the following steps:
232
1. Provide required values by setting environment variables.
233
234
The following example does these actions:
235
236
- Installs SSIS
237
- Specifies the Developer edition by providing a value for the `SSIS_PID` environment variable
238
- Accepts the Microsoft Software License Terms by providing a value for the `ACCEPT_EULA` environment variable
239
- Runs an unattended setup by specifying the `-n` (no prompt) option
241
```bash
242
sudo SSIS_PID=Developer ACCEPT_EULA=Y /opt/ssis/bin/ssis-conf -n setup
248
| --- | --- |
249
| `ACCEPT_EULA` | Accepts the SQL Server license terms when set to any value like `Y`. |
250
| `SSIS_PID` | Sets the SQL Server edition or product key. Here are the possible values:<br /><br />- Evaluation<br />- Developer<br />- Express<br />- Web<br />- Standard<br />- Enterprise<br />- A product key<br /><br />If you specify a product key, it must be in the form `#####-#####-#####-#####-#####`, where `#` is a letter or a digit. |
254
- [Extract, transform, and load data on Linux with SSIS](sql-server-linux-migrate-ssis.md)
255
- [Configure SQL Server Integration Services on Linux with ssis-conf](sql-server-linux-configure-ssis.md)
256
- [Limitations and known issues for SSIS on Linux](sql-server-linux-ssis-known-issues.md)
257
- [Schedule SQL Server Integration Services package execution on Linux with cron](sql-server-linux-schedule-ssis-packages.md)