First published on MSDN on May 17, 2017
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
Package on Ubuntu, follow these steps:
$ curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
Import the public repository GPG keys:
$ curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server.list | sudo tee /etc/apt/sources.list.d/mssql-server.list
Register the Microsoft SQL Server Ubuntu repository:
$ sudo apt-get update
$ sudo apt-get install -y mssql-server-is
Run the following commands to install SQL Server Integration Services:
$ sudo /opt/ssis/bin/ssis-conf setup
After installation, please run
$ export PATH=/opt/ssis/bin:$PATH
Once the configuration is done, set path:
$ sudo gpasswd -a "current user" ssis
If you user is not in
group, add current user to ssis group:
$ dtexec /F "your package" /DE "protection password"
Copy your SSIS package to your Linux machine and run:
The latest CTP 2.1 refresh build, we have ODBC support. Details refer to