Download Integration Package

https://packages.microsoft.com/keys/microsoft.asc

Copy files

 Copy microsoft.asc file to Copy file in /etc/yum.repos.d/firectory 

Installation Steps for Integration services:

1. check package information of mssql

YUM (Yellowdog Updater Modified) is an open source command-line .It allows users and system administrator to easily install, update, remove or search software packages on a systems.

yum install mssql-server -y

Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: centos.mirror.net.in
 * epel: kartolo.sby.datautama.net.id
 * extras: centos.excellmedia.net
 * updates: centos.excellmedia.net
Installed Packages
Name  : mssql-server
Arch  : x86_64
Version  : 14.0.900.75
Release  : 1
Size  : 870 M
Repo  : installed
From repo  : packages-microsoft-com-mssql-server
Summary  : Microsoft SQL Server Relational Database Engine
License  : Commercial
Description : The mssql-server package contains the Microsoft SQL Server Relational Database Engine.

 If you want to install packages automatically without asking any confirmation, use option -y .

#

2.Install Integration services package.

yum install mssql-server -y
Loaded plugins: fastestmirror
HDP-2.4   | 2.9 kB  00:00
HDP-UTILS-1.1.0.20   | 2.9 kB  00:00
Updates-ambari-2.4.0.1   | 2.9 kB  00:00
base   | 3.6 kB  00:00
epel/x86_64/metalink   | 7.1 kB  00:00
extras   | 3.4 kB  00:00
mongodb-enterprise   | 2.5 kB  00:00
https://repo.mongodb.org/yum/redhat/7/mongodb-org/3.4/x86_64/repodata/repomd.xml ;    : [Errno 14] curl#6 - "Could not resolve host: repo.mongodb.org; Name or service    not known"
Trying other mirror.
http://repo.mysql.com/yum/mysql-5.7-community/el/6/x86_64/repodata/repomd.xml: [    Errno 14] curl#6 - "Could not resolve host: repo.mysql.com; Name or service not    known"
Trying other mirror.
https://packages.microsoft.com/rhel/7/mssql-server/repodata/repomd.xml: [Errno 1    4] curl#6 - "Could not resolve host: packages.microsoft.com; Name or service not    known"
Trying other mirror.
packages-microsoft-com-prod  | 2.9 kB  00:00
updates   | 3.4 kB  00:00
Loading mirror speeds from cached hostfile
 * base: centos.mirror.net.in
 * epel: kartolo.sby.datautama.net.id
 * extras: centos.excellmedia.net
 * updates: centos.excellmedia.net
Resolving Dependencies
There are unfinished transactions remaining. You might consider running yum-complete-transaction, or "yum-complete-transaction --cleanup-only" and"yum history    redo last", first to finish them. If those don't work you'll have to try removin    g/installing packages by hand (maybe package-cleanup can help).
The program yum-complete-transaction is found in the yum-utils package.
--> Running transaction check
---> Package mssql-server-is.x86_64 0:14.0.900.75-1 will be installed
--> Finished Dependency Resolution
  
Dependencies Resolved
  
================================================================================
 Package  Arch  Version  Repository  Size
================================================================================
Installing:
 mssql-server-is x86_64 14.0.900.75-1 packages-microsoft-com-mssql-server 175 M
  
Transaction Summary
================================================================================
Install  1 Package
  
Total download size: 175 M
Installed size: 836 M
Downloading packages:
Delta RPMs disabled because /usr/bin/applydeltarpm not installed.
mssql-server-is-14.0.900.75-1.x86_64.rpm  | 175 MB  01:04
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
 Installing : mssql-server-is-14.0.900.75-1.x86_64  1/1
 Verifying  : mssql-server-is-14.0.900.75-1.x86_64  1/1
  
Installed:
 mssql-server-is.x86_64 0:14.0.900.75-1
  
Complete!

3. check progress Integration services install

# rpm -qa | grep mssql
mssql-tools-14.0.6.0-1.x86_64
mssql-server-14.0.900.75-1.x86_64
mssql-server-fts-14.0.900.75-1.x86_64
mssql-server-is-14.0.900.75-1.x86_64       ---Integration services is install
mssql-server-agent-14.0.900.75-1.x86_64

4.Configuration Integration services

#sudo /opt/ssis/bin/ssis-conf setup
Do you accept the license terms? [Yes/No]:y
  
Choose an edition of
SSIS:
 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) I bought a license through a retail sales channel andhave a product key to
  
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-7): 1
Only userin 'ssis'group can run 'dtexec' onLinux. Do you want to add current
Please logout to reload the group information.
SSIS telemetry service is now running.
Setup has completed successfully.

5.Set path for Integration services

export PATH=/opt/ssis/bin:$PATH

6. Remove Integration services

sudo yum remove package-->To uninstall a particular package
# sudo yum remove mssql-server-is
Loaded plugins: fastestmirror
Resolving Dependencies
There are unfinished transactions remaining. You might consider running yum-complete-transaction, or"yum-complete-transaction --cleanup-only" and"yum history redo last", first tofinish them. If those don't work you'll have to try removing/installing packages by hand (maybe package-cleanup can help).
The program yum-complete-transaction is found inthe yum-utils package.
--> Running transaction check
---> Package mssql-server-is.x86_64 0:14.0.900.75-1 will be erased
--> Finished Dependency Resolution
 
Dependencies Resolved
 
=======================================================================================
 Package  Arch  Version  Repository   Size
=======================================================================================
Removing:
 mssql-server-is  x86_64  14.0.900.75-1  @packages-microsoft-com-mssql-server  836 M
 
Transaction Summary
===============
Remove  1 Package
 
Installed size: 836 M
Is this ok [y/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
 Erasing  : mssql-server-is-14.0.900.75-1.x86_64     1/1
 Verifying  : mssql-server-is-14.0.900.75-1.x86_64     1/1
 
Removed:
 mssql-server-is.x86_64 0:14.0.900.75-1
 Complete!

7.Check Integration uninstall completed

RPMs can be used to,
  • Install packages
  • Remove packages
  • Upgrade packages
  • Verify packages
# rpm -qa | grep mssql --Verify if the package is installed or not
mssql-tools-14.0.6.0-1.x86_64
mssql-server-14.0.900.75-1.x86_64
mssql-server-fts-14.0.900.75-1.x86_64
mssql-server-agent-14.0.900.75-1.x86_64

Reference

Suggested Readings