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
|
Sponsored Link |
|