CentOS 7
Sponsored Link

SQL Server 2019 : Integration Services
2020/01/17
 
SQL Server Integration Services (SSIS) をインストールすると、クライアントコンピューターからデータのコピーや変換等々が容易に実行できるようになります。
[1] SQL Server Integration Services をインストールします。(MS SQL 2019 リポジトリより)
[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=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.

# 利用するエディションを選択
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

Setup has completed successfully.

[root@dlp ~]#
usermod -G 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]
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

関連コンテンツ