CentOS 7
Sponsored Link

SQL Server 2017 : Integration Services2017/10/10

 
Install SQL Server Integration Services (SSIS) to enable data integration or data transformations.
[1] Install SQL Server Integration Services. (from MS SQL 2017 repo)
[root@dlp ~]#
yum -y install mssql-server-is
[2] Run initial Setup for SSIS.
[root@dlp ~]#
/opt/ssis/bin/ssis-conf setup

Choose an edition of SQL Server:
  1) Evaluation (free, no production use rights, 180-day limit)
  2) Developer (free, no production use rights)
  3) Express (free)
  4) Web (PAID)
  5) Standard (PAID)
  6) Enterprise (PAID)
  7) Enterprise Core (PAID)
  8) I bought a license through a retail sales channel and have a product key to enter.

Details about editions can be found at
https://go.microsoft.com/fwlink/?LinkId=852748&clcid=0x409

Use of PAID editions of this software requires separate licensing through a
Microsoft Volume Licensing program.
By choosing a PAID edition, you are verifying that you have the appropriate
number of licenses in place to install and run this software.

# select an edition you'd like to use
Enter your edition(1-8): 2
The license terms for this product can be downloaded from:
https://go.microsoft.com/fwlink/?LinkId=855862&clcid=0x409

The privacy statement can be viewed at:
https://go.microsoft.com/fwlink/?LinkId=853010&clcid=0x409

# agree to the license
Do you accept the license terms? [Yes/No]:y

Telemetry service is now running.
Setup has completed successfully.

[root@dlp ~]#
systemctl status ssis-telemetry

* ssis-telemetry.service - Microsoft SQL Server Telemetry Service
   Loaded: loaded (/usr/lib/systemd/system/ssis-telemetry.service; enabled; vendor preset: disabled)
   Active: active (running) since Tue 2017-10-10 19:33:11 JST; 18min ago
 Main PID: 2038 (ssis-telemetry)
   CGroup: /system.slice/ssis-telemetry.service
           ├─2038 /opt/ssis/bin/ssis-telemetry
           └─2058 /opt/ssis/bin/ssis-telemetry

Oct 10 19:33:11 dlp.srv.world systemd[1]: Started Microsoft SQL Server Telem....
Oct 10 19:33:11 dlp.srv.world systemd[1]: Starting Microsoft SQL Server Tele....
Hint: Some lines were ellipsized, use -l to show in full.

[root@dlp ~]#
echo 'export PATH=$PATH:/opt/ssis/bin' > /etc/profile.d/ssis.sh

[root@dlp ~]#
source /etc/profile.d/ssis.sh

[3]
The user interface of SSIS is provided for only Windows now, so it's possible to operate SSIS on Windows clients. You can use SSMS or SQL Server Data Tools (SSDT) for Visual Studio below. (but possible to execute SSIS packages with T-SQL)
⇒ https://docs.microsoft.com/ja-jp/sql/ssdt/download-sql-server-data-tools-ssdt

Matched Content