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 (email@example.com) 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:
- 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:
$ curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server.list | sudo tee /etc/apt/sources.list.d/mssql-server.list
- Run the following commands to install SQL Server Integration Services:
$ sudo apt-get update
$ sudo apt-get install -y mssql-server-is
- After installation, please run ssis-conf:
$ sudo /opt/ssis/bin/ssis-conf setup
- Once the configuration is done, set path:
$ export PATH=/opt/ssis/bin:$PATH
- If you user is not in ssis group, add current user to ssis group:
$ sudo gpasswd -a "current user" ssis
- 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 https://blogs.msdn.microsoft.com/ssis/2017/06/16/odbc-is-supported-in-ssis-on-linux-ssis-helsinki-ctp2-1-refresh/