SQL integration services service port used

Question

Hello we have the situation where we have an app run SSIS to update data on database. The app is published and the SSIS packages are on the same server , the database on another service. There is SQL integration services service installed on the server that has the app and SSIS packages. I want to know which is port is used to run SSIS? is it port 135 and if we close this port , the SSIS will not run or as the app and SSIS are on the same server , there is no need to use the port

Answer 1

Hi @Sayed, Shaimaa ，

The Integration Services service uses port 135, and the port cannot be changed. You have to open TCP port 135 for access to the service control manager (SCM). SCM performs tasks such as starting and stopping Integration Services services and transmitting control requests to the running service.

For more details, please refer to integration-services-service-ssis-service.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

Hi @Sayed, Shaimaa ,

If your SSIS run-time environment on the server is 2012 or later, there is no need in SSIS Service.
It is kept just for backward compatibility with the obsolete SSIS 2005 and 2008.

It explicitly documented by Microsoft: integration-services-service-ssis-service

This service is not required to create, save, and run Integration Services packages. SQL Server 2012 (11.x) supports the Integration Services service for backward compatibility with earlier releases of Integration Services.

As end result, no need to worry about the SSIS service.