SQL SSIS and service pack upgrade

03 June,2011 by Tom Collins

SSIS 2005 latest service pack upgrade.How to create instructions for tech support to upgrade the SSIS version

From the following link http://support.microsoft.com/kb/942177  find out your SSIS version

 For example :

I have this  SSIS version in blue in the following table:


Service pack level

Version number

Name of the root node

The release version of SSIS


MyServerName (Integration Services 9.0.1399 - MyDomain\MyUser)

SSIS with Service Pack 1 (SP1)


MyServerName (Integration Services 9.0.2047 - MyDomain\MyUser)

SSIS with Service Pack 2 (SP2)


MyServerName (Integration Services 9.0.3042 - MyDomain\MyUser)


To upgrade the SSIS version to 9.0.3042, download from


Source:Jack Vamvas (http://www.sqlserver-dba.com)

Author: Tom Collins (http://www.sqlserver-dba.com)


Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment on SQL SSIS and service pack upgrade

sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer