Integration Services is the management interface for SSIS packages. SQL Server uses the “MsDtsSrvr.exe” for executing packages
To highlight the point, configuring the firewall to access Integration Services requires allowing access to port 135 for the “MsDtsSrvr.exe”.
Access the MsDtsSrvr.exe file to view the version number
- Find and open the following folder:
“%programfiles%\Microsoft SQL Server\90\DTS\Binn\”
- Right-click the MsDtsSrvr.exe file | click Properties.
- Click the Version tab.
- View the text after the File version label. The text is the SSIS version number.
The version number represents the SSIS service pack level or the SSIS hotfix level. For SQL SSIS and service pack upgrade
