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

9.0.1399

MyServerName (Integration Services 9.0.1399 - MyDomain\MyUser)

SSIS with Service Pack 1 (SP1)

9.0.2047

MyServerName (Integration Services 9.0.2047 - MyDomain\MyUser)

SSIS with Service Pack 2 (SP2)

9.0.3042

MyServerName (Integration Services 9.0.3042 - MyDomain\MyUser)

Ssis 

To upgrade the SSIS version to 9.0.3042, download from

http://www.microsoft.com/downloads/en/details.aspx?FamilyId=D07219B2-1E23-49C8-8F0C-63FA18F26D3A&displaylang=en

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

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


Share:

Verify your Comment

Previewing your Comment

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

Working...
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.

Working...

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