Microsoft KB Archive/942177

= How to determine the version of SQL Server 2005 Integration Services =

Article ID: 942177

Article Last Modified on 11/20/2007

-

APPLIES TO


 * 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

-



SUMMARY
This article describes how to determine the version of Microsoft SQL Server 2005 Integration Services (SSIS) that is installed on a computer.



MORE INFORMATION
You can determine the SSIS version by using one of the following methods.

Notes
 * 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

 * 1) Open SQL Server Management Studio.
 * 2) In the Connect to Server dialog box, click Integration Services in the Server type list.
 * 3) In the Server name box, specify the SSIS server name, and then click Connect.
 * 4) In Object Explorer, view the version number in the name of the root node.

The name of the root node appears in the following syntax:

(Integration Services  –  \ )

Notes
 * represents the SSIS server name. Usually, the SSIS server name is the network name of the computer that is running SSIS.
 * respents the SSIS service pack level or the SSIS hotfix level.
 * represents the user name that you use to connect to SSIS.
 * represents the name of the domain that the user belongs to. If the user does not belong to a domain,  represents the name of the computer that is running SSIS.

For example, assume the SSIS server name is MyServerName. The domain name is MyDomain. The user name is MyUser. The following table lists the service pack level, the version number, and the corresponding name of the root node:

Method 2: Use the MsDtsSrvr.exe file
Note 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.

The version number represents the SSIS service pack level or the SSIS hotfix level.The following table lists the SSIS service pack level and the corresponding 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.

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:

</li> 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.</li></ol>

The following table lists the SSIS service pack level and the corresponding value of the Version registry entry.

Method 4: Use the Application log

 * 1) Click Start, click Run, type Eventvwr, and then click OK.
 * 2) In the Event Viewer window, click Application.
 * 3) Locate the event that meets the following requirements:
 * 4) * The value in the Event column is 257.
 * 5) * The value in the Source column is SQLISService.
 * 6) * 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.
 * 7) Double-click the event that you located in step 3.
 * 8) In the Event Properties dialog box, view the Server version   text under Description.

represents the SSIS service pack level or the SSIS hotfix level.

The following table lists the SSIS service pack level and the corresponding  value.

Keywords: kbhowto kbinfo kbexpertiseadvanced kbexpertiseinter kbexpertisebeginner kbsql2005ssis KB942177

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.