Solved

incorrect version numbe rerror

Posted on 2011-09-27
16
866 Views
Last Modified: 2013-11-10
what does version mean in a package and how to fix it?
0
Comment
Question by:25112
16 Comments
 
LVL 5

Author Comment

by:25112
ID: 36710700
the full error is
Error Loading Package: the version number in the package is not valid. The version number cannot be greater than current version number.

Error Loading Package: 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."

Error	3	Error loading package: Error loading value "<DTS:Property xmlns:DTS="www.microsoft.com/SqlServer/Dts" DTS:Name="PackageFormatVersion">3</DTS:Property>" from node "DTS:Property".  	1	

Error	4	Error Loading Package: The package failed to load due to error 0xC0010014 "One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors.". This occurs when CPackage::LoadFromXML fails.  .

Open in new window

0
 
LVL 21

Accepted Solution

by:
Jason Yousef, MS earned 400 total points
ID: 36710728
0
 
LVL 50

Assisted Solution

by:Lowfatspread
Lowfatspread earned 50 total points
ID: 36710947
the error means you have created the package under one environment and are now trying to run it in an environment which is actually running a prior version of sql server.

you need to develop / test and deploy your package under the same operating environment

it is normally possible for an edition/version of sql server to run packages developed in a prior version, but never code developed in future versions.

(versions can include different fixpack levels)
0
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
LVL 5

Author Comment

by:25112
ID: 36711697
OK, so in development, you should 'save as' with 2005 version? is that the only step? There didn't seem clear indication of that in the msdn post..
0
 
LVL 21

Expert Comment

by:Jason Yousef, MS
ID: 36711847
No there's no save as 2005, if you'll develop the package under BIDS 2008 or visual studio 2008, the package will be a 2008 package.

if using BIDS 2005 or visual studio 2005 , the package will be a 2005 package.

Now, when you schedule the packages, you'll need to specify which DTEXEC the sql agent uses...see the attached screen
http://msdn.microsoft.com/en-us/library/ms162810.aspx

 a

Also if you'll open a 2005 package in BIDS 2008 it'll be upgraded
http://msdn.microsoft.com/en-us/library/cc280546.aspx
0
 
LVL 21

Assisted Solution

by:Alpesh Patel
Alpesh Patel earned 50 total points
ID: 36715952
Hey, You are trying to load the SQL 2008 SSIS package to SQL Server 2005 BIDS.

You cannot do this. To open in SQL Server 2005 BIDS you need to update package manually.
0
 
LVL 5

Author Comment

by:25112
ID: 36716173
>>To open in SQL Server 2005 BIDS you need to update package manually.
how can i be done manually?

it will be nice if the package does not have to be started from scratch in 2005.. since lot of work was already done in the 2008 package..

(I assume 2005 package can be opened in 2008, but will make (convert) into 2008 format permanently?)
0
 
LVL 21

Expert Comment

by:Jason Yousef, MS
ID: 36716476
Yes it'll be upgraded to 2008 permanently, so save a backup...
0
 
LVL 5

Author Comment

by:25112
ID: 36716802
>>Yes it'll be upgraded to 2008 permanently, so save a backup...

OK.. but what about one that is already saved permanently.. the work has to be started from scratch in 2005? can you please confirm.
0
 
LVL 21

Expert Comment

by:Jason Yousef, MS
ID: 36716827
YES< can be downgraded again or used in 2005

More consideration before upgrading is here:

http://stackoverflow.com/questions/179542/what-to-keep-in-mind-while-migrating-ssis-packages-from-sql-server-2005-to-2008

Remember always to take a backup copy before touching anything...
0
 
LVL 5

Author Comment

by:25112
ID: 36716861
>>YES< can be downgraded again or used in 2005

Do you mean there is a way to convert 2008 back to 2005? how? thanks for the link- but it talks about the reverse route - from 2005 to 2008.
0
 
LVL 21

Expert Comment

by:Jason Yousef, MS
ID: 36716878
I meant to say NO, sorry !!! it's a big typo !!  I copied and pasted your question with the YES
0
 
LVL 21

Expert Comment

by:Jason Yousef, MS
ID: 36716880
SSIS Packages designed in VS 2008 CANNOT be run in VS 2005 or installed in
SQL 2005 instances.

However, packages desinged in VS 2005 CAN be installed in SQL 2008. But if
you open the package in VS 2008, it will want to upgrade the package, making
it un-usable for 2005 versions.
0
 
LVL 5

Author Comment

by:25112
ID: 36716932
thanks for the clarification.. so 'start again from scratch' is the only option, right?
0
 
LVL 21

Assisted Solution

by:Jason Yousef, MS
Jason Yousef, MS earned 400 total points
ID: 36716950
YES, once upgraded it becomes in-usable for 2005 versions...
0
 
LVL 5

Author Comment

by:25112
ID: 36717028
thanks for your help
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how the fundamental information of how to create a table.

778 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question