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