How to determine the version of SQL Server 2005 Integration Services
This article describes how to determine the version of Microsoft SQL Server 2005 Integration Services (SSIS) that is installed on a computer.
You can determine the SSIS version by using one of the following methods.
- SSIS does not support multiple instances. You can only install one instance of SSIS on a computer.
- Method 1 is the easiest method to determine the version of SSIS.
- If you cannot connect to the SSIS server, use Method 2, Method 3, or Method 4.
Method 1: Use Object Explorer
- Open SQL Server Management Studio.
- In the Connect to Server dialog box, click Integration Services in the Server type list.
- In the Server name box, specify the SSIS server name, and then click Connect.
- In Object Explorer, view the version number in the name of the root node.
Server_Name (Integration Services Version_No – Domain_Name\User_Name)Notes
- Server_Name represents the SSIS server name. Usually, the SSIS server name is the network name of the computer that is running SSIS.
- Version_No respents the SSIS service pack level or the SSIS hotfix level.
- User_Name represents the user name that you use to connect to SSIS.
- Domain_Name represents the name of the domain that the user belongs to. If the user does not belong to a domain, Domain_Name represents the name of the computer that is running SSIS.
|Service pack level||Version number||Name of the root node|
|The release version of SSIS||9.0.1399||MyServerName (Integration Services 9.0.1399 - MyDomain\MyUser)|
|SSIS with Service Pack 1 (SP1)||9.0.2047||MyServerName (Integration Services 9.0.2047 - MyDomain\MyUser)|
|SSIS with Service Pack 2 (SP2)||9.0.3042||MyServerName (Integration Services 9.0.3042 - MyDomain\MyUser)|
Method 2: Use the MsDtsSrvr.exe fileNote The MsDtsSrvr.exe file is the SSIS service executable file.
- Open the following folder:%programfiles%\Microsoft SQL Server\90\DTS\Binn\
- Right-click the MsDtsSrvr.exe file, and then click Properties.
- In the MsDtsSrvr.exe Properties dialog box, click the Version tab.
- On the Version tab, view the text after the File version label. The text is the SSIS version number.
If the server is running a 64-bit version of SSIS, the MsDtsSrvr.exe file is a 64-bit file. No 32-bit version of the MsDtsSrvr.exe file exists on the server. However, other SSIS executable files and SSIS DLLs have a corresponding 32-bit version file and a 64-bit version file. For example, on a server that is running a 64-bit version of SSIS, the DTExec.exe file has a 32-bit version file and a 64-bit version file.
|Service pack level||Text after the "File version" label|
|The release version of SSIS||9.0.1399.0|
|SSIS with SP1||9.0.2047.0|
|SSIS with SP2||9.0.3042.0|
Method 3: Use the registry
- Click Start, click Run, type Regedit, and then click OK.
- In Registry Editor, locate the following registry subkey:Note If you are running a 32-bit version of SSIS on a 64-bit version of the Microsoft Windows operating system, locate the following registry subkey:HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\DTS\SetupHKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\90\DTS\Setup
- In the Data column, view the value of the Version registry entry and the value of the Patchlevel registry entry.
The value of the Version registry entry represents the SSIS service pack level. The value of the Patchlevel registry entry represents the SSIS hotfix level.
|Service pack level||Value of the Version registry entry|
|The release version of SSIS||9.00.1399.06|
|SSIS with SP1||9.1.2047.00|
|SSIS with SP2||9.2.3042.00|
Method 4: Use the Application log
- Click Start, click Run, type Eventvwr, and then click OK.
- In the Event Viewer window, click Application.
- Locate the event that meets the following requirements:
- The value in the Event column is 257.
- The value in the Source column is SQLISService.
- The event is the most recent event of a series of similar events. To determine the most recent event, view the value in the Data column and the value in the Time column.
- Double-click the event that you located in step 3.
- In the Event Properties dialog box, view the Server version Version_Num text under Description.
Version_Num represents the SSIS service pack level or the SSIS hotfix level.
|Service pack level||Version_Num in the "Server version Version_Num" text|
|The release version of SSIS||9.00.1399.00|
|SSIS with SP1||9.00.2047.00|
|SSIS with SP2||9.00.3042.00|
Article ID: 942177 - Last Review: 06/21/2014 13:54:00 - Revision: 2.0
Microsoft SQL Server 2005 Workgroup Edition, Microsoft SQL Server 2005 Standard Edition, Microsoft SQL Server 2005 Developer Edition, Microsoft SQL Server 2005 Enterprise Edition, Microsoft SQL Server 2005 Standard X64 Edition, Microsoft SQL Server 2005 Enterprise X64 Edition, Microsoft SQL Server 2005 Standard Edition for Itanium-based Systems, Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems
- kbsqlsetup kbsql2005ssis kbexpertiseadvanced kbexpertisebeginner kbexpertiseinter kbhowto kbinfo KB942177