• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1120
  • Last Modified:

incorrect version numbe rerror

what does version mean in a package and how to fix it?
0
25112
Asked:
25112
4 Solutions
 
25112Author Commented:
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
 
Jason Yousef, MSSr. BI DeveloperCommented:
0
 
LowfatspreadCommented:
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
25112Author Commented:
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
 
Jason Yousef, MSSr. BI DeveloperCommented:
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
 
Alpesh PatelAssistant ConsultantCommented:
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
 
25112Author Commented:
>>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
 
Jason Yousef, MSSr. BI DeveloperCommented:
Yes it'll be upgraded to 2008 permanently, so save a backup...
0
 
25112Author Commented:
>>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
 
Jason Yousef, MSSr. BI DeveloperCommented:
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
 
25112Author Commented:
>>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
 
Jason Yousef, MSSr. BI DeveloperCommented:
I meant to say NO, sorry !!! it's a big typo !!  I copied and pasted your question with the YES
0
 
Jason Yousef, MSSr. BI DeveloperCommented:
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
 
25112Author Commented:
thanks for the clarification.. so 'start again from scratch' is the only option, right?
0
 
Jason Yousef, MSSr. BI DeveloperCommented:
YES, once upgraded it becomes in-usable for 2005 versions...
0
 
25112Author Commented:
thanks for your help
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now