Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Version error when trying to edit SSIS package Expand / Collapse
Author
Message
Posted Wednesday, October 9, 2013 8:30 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 10, 2013 12:59 PM
Points: 4, Visits: 4
I recently upgraded my SSMS 2008 to 2008 R2 to allow me to view SSIS packages through Integration Services. Since the upgrade, I have been unable to open any SSIS modules through BIDS on Visual Studio 2005 - the same version in which the packages were created. I get the following error:
Package migration from version 3 to version 2 failed with error 0xC001700A "The version number in the package is not valid. The version number cannot be greater than current version number.".

I have seen similar topics on this issue, all relating to getting this error when running the packages and all the solutions seem to revolve around opening the package in the VS 2005 and saving as a 2005 package. Since I can not even open these packages, does anyone have any suggestions for getting around this error?
Post #1503133
Posted Wednesday, October 9, 2013 8:36 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:59 AM
Points: 5,227, Visits: 9,437
Are the packages stored in msdb or in the file system? Have you tried opening them with Visual Studio 2008?

John
Post #1503137
Posted Wednesday, October 9, 2013 8:47 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 10, 2013 12:59 PM
Points: 4, Visits: 4
They are stored in the file system. I don't have Visual Studio 2008 available (SQL Server 2008, but not VS 2008), so I am not able to use it to open the package.
Post #1503150
Posted Wednesday, October 9, 2013 8:49 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:59 AM
Points: 5,227, Visits: 9,437
But you upgraded to SSMS R2 using the installation DVD, right? You should be able to install Visual Studio (BIDS) from there.

John
Post #1503154
Posted Wednesday, October 9, 2013 8:55 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 10, 2013 12:59 PM
Points: 4, Visits: 4
I'll have to check. The install was done from a file share and I don't have complete access to the location (the joys of working for a large company that locks down EVERYTHING that might be helpful to a developer ). I don't remember seeing BIDS as an option to either include or ignore during the installation.
Post #1503155
Posted Wednesday, October 9, 2013 9:03 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:59 AM
Points: 5,227, Visits: 9,437
No, it will have been under something like Development Tools. It'll be documented somewhere.

John
Post #1503160
Posted Thursday, October 10, 2013 1:02 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 10, 2013 12:59 PM
Points: 4, Visits: 4
I poked around a little and found that I did have BIDS for 2008. I was able to open & update packages, after some playing around with the conversion wizard.

Thanks for your help in trouble-shooting!
Post #1503755
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse