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-comp    lete-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 and have a product key to
  
Details about editions can be found at
  
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 user in 'ssis' group can run 'dtexec' on Linux. 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 to finish 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 in the 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

remove package from Centos        


Suggested Readings


  Important

Do NOT add your article candidate into the COMMENTS section.

Your article will NOT participate in the competition as the judging tool can only detect articles in the body of this article, not in the comments.

Make sure to add the link IN THE ARTICLE, in the sections below.

 

  Important

Do NOT add your article candidate into the COMMENTS section.

Your article will NOT participate in the competition as the judging tool can only detect articles in the body of this article, not in the comments.

Make sure to add the link IN THE ARTICLE, in the sections below.