Mon 4 Jan 2010
SSIS 2008 – Beware of incorrect version stamp in SSMS
Posted by Phil Brammer under SQL Server 2008 , SSIS1 Comment
There is a bug where even if you have applied a patch or service pack to SSIS 2008, the version listed next to the “Integration Services” service in Management Studio continues to show 10.0.1600, which is the version number for RTM.
As always, if you are unsure, it is best to determine the actual version by looking at the files themselves, ie. dtexec.exe, or by confirming the version number in BIDS via Help->About.
While this isn’t a big deal, it is an annoyance. I’ve got the question out to the product team for their response, so stay tuned for more information as it becomes available.
EDIT – Please see Matt Masson’s (SSIS Product Team) comments below.
January 4th, 2010 at 2:10 pm
FYI – the problem was that the service’s EXE file (MsDtsSrvr.exe) was flagged so that it would only be updated if it was changed in that patch. The patching configuration was updated to make sure that it gets replaced every time (the same as dtexec).
I believe the fix will start showing up in 2008 R2 and beyond.