SSIS on Linux is available in SQL Server 2017 CTP2.1
Published Mar 25 2019 04:07 PM 2,269 Views
Not applicable
First published on MSDN on May 17, 2017
Dear all,

I am very pleased to announce that the Linux version SSIS is available in CTP 2.1.

Since March 2016 Microsoft announced that SQL Server plan to support Linux platform, SSIS team has been working on any possibility to also support SSIS on Linux OS. Now you can download SQL Server Integration Services CTP 2.1 and try it out on your Linux machines or VM by command lines.

In this version, you can:

  • Run SSIS packages on Linux OS, monitor and track execution status and result;

  • Extract data from and to most common used sources and destinations on Linux platform;

  • Do common used transformation on Linux platform;

SSIS on Linux is one of key investments in 2017. So please email me directly ( ) if you have any feedbacks on it.

Installing the SSIS Package on Ubuntu

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

  1. Import the public repository GPG keys:

$ curl | sudo apt-key add -

  1. Register the Microsoft SQL Server Ubuntu repository:

$ curl | sudo tee /etc/apt/sources.list.d/mssql-server.list

  1. Run the following commands to install SQL Server Integration Services:

$ sudo apt-get update

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

  1. After installation, please run ssis-conf :

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

  1. Once the configuration is done, set path:

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

  1. If you user is not in ssis group, add current user to ssis group:

$ sudo gpasswd -a "current user" ssis

  1. Copy your SSIS package to your Linux machine and run:

$ dtexec /F "your package" /DE "protection password"

The latest CTP 2.1 refresh build, we have ODBC support. Details refer to

Version history
Last update:
‎Mar 25 2019 04:07 PM
Updated by: