CentOS 7
Sponsored Link

SQL Server 2019 : Integration Services2020/01/20

 
Install SQL Server Integration Services (SSIS) to enable data integration or data transformations.
[1] Install SQL Server Integration Services. (from MS SQL 2019 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=2111701&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 term
Do you accept the license terms? [Yes/No]:y

Setup has completed successfully.

[root@dlp ~]#
usermod -aG mssql ssis

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

[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 Fri 2020-01-16 21:52:34 JST; 1min 10s ago
 Main PID: 19271 (ssis-telemetry)
   CGroup: /system.slice/ssis-telemetry.service
           +-19271 /opt/ssis/bin/ssis-telemetry
           +-19273 /opt/ssis/bin/ssis-telemetry

Jan 16 21:52:34 dlp.srv.world systemd[1]: Started Microsoft SQL Server Telem....
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