SSIS 2008 – Beware of incorrect version stamp in SSMS

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.

4 thoughts on “SSIS 2008 – Beware of incorrect version stamp in SSMS

  • Matt Masson

    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.

  • Arthur

    A question is if I see 10.0.1600.22 what does this mean?
    And most importantly if a package was created on SQL Server 2008 SP and then deployed to a box that sits on SP1 will it run?

  • Pingback: SSIS Links Collections « My experiments with SQL Server…!

  • Pingback: SSIS Links Collections « My experiments with SQL Server…!

Comments are closed.