SQL Server 2017 : Integration Services2017/10/10 |
SQL Server Integration Services (SSIS)
をインストールすると、クライアントコンピューターからデータのコピーや変換等々が容易に実行できるようになります。
|
|
[1] | SQL Server Integration Services をインストールします。(MS SQL 2017 リポジトリより) |
[root@dlp ~]# yum -y install mssql-server-is
|
[2] | 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. # 利用するエディションを選択 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 # ライセンス条項に同意 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] |
SSIS 用のユーザーインターフェースは、現時点では Windows 用のみ提供されているため、操作は
Windows クライアントからとなります。SSMS や SQL Server Data Tools (SSDT) for Visual Studio などから利用できます。
(作成した SSIS パッケージの実行は Transact-SQL からでも可能)
⇒ https://docs.microsoft.com/ja-jp/sql/ssdt/download-sql-server-data-tools-ssdt
|
Sponsored Link |