Microsoft Download Centre Download Page
An updated for BOL also accompanied SP2, SQL Server 2005 Books Online - February 2007
For more details and options see Microsoft SQL Server 2005 Service Pack 2
The traditional method for checking the version of SQL Server installed is to query the value of the @@VERSION function, but if you have only have SSIS installed, you need a SSIS specific method. A very simple method is to check the File Version of the SSIS Service, C:\Program Files\Microsoft SQL Server\90\DTS\Binn\MsDtsSrvr.exe. Right-click the file and select Properties. On the Version tab check the File Version property and compare with the table below. RTM shows 9.00.1399.00, SP1 shows 9.00.2047.00
Strictly speaking the MsDtsSrvr.exe may not always be updated with a service pack or patch, so this version may reflect an older level. An alternative method is to check the registry HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\DTS\Setup, values Version and PatchLevel which give the service pack and hotfix level respectively. Current values are given in the table below.
| Version | @@VERSION | MsDtsSrvr.exe File Version | Registry Version | Registry Patch Level |
| Release to Manufacturing | 9.00.1399.00 | 9.0.1399.0 | 9.0.1399.06 | 9.0.1399.06 |
| Service Pack 1 | 9.00.2047.00 | 9.0.2047.0 | 9.1.2047.00 | 9.1.2047.00 |
| Post SP1 Cumulative Hotfix | 9.0.2153.00 | 9.0.2153.0 | 9.1.2047.00 | 9.1.2153 |
| Service Pack 2 CTP | 9.00.3027.00 | 9.0.3027.0 | 9.2.3027.00 | 9.2.3027.00 |
| Service Pack 2 | 9.00.3042.00 | 9.0.3042.0 | 9.2.3042.00 | 9.2.3042 |
| Service Pack 2 Rollup 3 | 9.00.3186.0 | 9.00.3186.00 | 9.2.3042.00 | 9.2.3186 |
Another place you can check the version of SSIS is through the designer, Visual Studio aka BIDS. See the BIDS page for an example, notice the version is shown in the Product Details box. This raises the point of workstation machines, do not forget to patch you clients. It is no good having a great server with all the fixes on if your tools and designers are out of date.
Microsoft have also recently published a KB article on finding the SSIS version which can be found here http://support.microsoft.com/default.aspx?scid=kb;en-us;942177&sd=rss&spid=2855
No major issues repported.