It’s Great news that now SQL Server Integration service’s  Linux version SSIS is available in CTP 2.1.It’s initial step to toward platform independence .According to the Microsoft Program Manager Leo Li  “SQL Server Integration Services CTP 2.1 and try it out on your Linux machines or VM by command lines.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"

First of all we need to install SQL Server 2017 on Ubuntu that I’ve write in my blog Install Microsoft SQL Server On Ubuntu 17.04

I’ve tried to install SSIS on Ubuntu according to the Leo Li’s blog :

  1. First we have to import the public repository GPG keys:
   curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add
  1. It's important to aligned repository to install SSIS .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
  1. Now we're going to install by SSIS using commands below commands:
   sudo apt-get update

5

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

8
  1. In this step we need to configure ssis-conf:
       sudo /opt/ssis/bin/ssis-conf
  1. Once the configuration is done, set path:
      export PATH=/opt/ssis/bin:$PATH

    6. if you user is not in ssis group, add current user to ssis group:

        sudo gpasswd -a ahsan ssis

101

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

       dtexec /F “your package” /DE “protection password”