SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

SSIS version in SQL Server

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

  1. Find and open the following folder:

“%programfiles%\Microsoft SQL Server\90\DTS\Binn\”

  1. Right-click the MsDtsSrvr.exe file |  click Properties.
  2. Click the Version tab.
  3. 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

MsDtsSrvr version 


No comments.

Leave a Comment

Please register or log in to leave a comment.