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.
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:
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:
Service pack level
Text after the "File version" label
The release version of SSIS
SSIS with SP1
SSIS with SP2
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:
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