Solved

incorrect version numbe rerror

Posted on 2011-09-27
16
820 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:
huslayer 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
 
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:huslayer
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:huslayer
ID: 36716476
Yes it'll be upgraded to 2008 permanently, so save a backup...
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
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:huslayer
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:huslayer
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:huslayer
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:huslayer
huslayer 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how the fundamental information of how to create a table.

706 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now