SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


The package failed to load due to error 0xC0010014 "One or more error occurred.


The package failed to load due to error 0xC0010014 "One or more error occurred.

Author
Message
- Win.
- Win.
SSCommitted
SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)

Group: General Forum Members
Points: 1506 Visits: 800
Dear Experts,

Could please help me in resolving the below error.... Trying to execute a .dtsx package, but facing the below error.......



TITLE: SSIS Execution Properties
------------------------------

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.


------------------------------
ADDITIONAL INFORMATION:

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.


------------------------------
BUTTONS:

OK
------------------------------

_____________________________________________________________________________________

Error: 2009-06-18 11:22:05.32
Code: 0xC001700A
Source:
Description: The version number in the package is not valid. The version number cannot be greater than current version number.
End Error
Error: 2009-06-18 11:22:05.33
Code: 0xC0016020
Source:
Description: 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.".
End Error
Error: 2009-06-18 11:22:05.33
Code: 0xC0010018
Source:
Description: Error loading value "roperty xmlnsBigGrinTS="www.microsoft.com/SqlServer/Dts" DTS:Name="PackageFormatVersion">3roperty>" from node "DTSTongueroperty".
End Error
Could not load package "D:\Execution Log Sample Reports\RSExecutionLog_Update.dtsx" because of error 0xC0010014.
Description: 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.
Source:

Cheers,
- Win.

" Have a great day "
CozyRoc
CozyRoc
SSCertifiable
SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)

Group: General Forum Members
Points: 6604 Visits: 2235
It looks like you are trying to execute SSIS package generated with SQL 2008 on SQL 2005 or something similar.

I'm talking about this error in particular:

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

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/


- Win.
- Win.
SSCommitted
SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)

Group: General Forum Members
Points: 1506 Visits: 800
Thanks for you reply CozyRoc,

But the package was created on 2005 server itself and am running this "RSExecutionLog_Update.dtsx" on my local machine.

My machine has SQL 2005 and SQL 2008 as well. Will this create any problems internally ??

Cheers,
- Win.

" Have a great day "
CozyRoc
CozyRoc
SSCertifiable
SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)

Group: General Forum Members
Points: 6604 Visits: 2235
winslet (6/18/2009)
Thanks for you reply CozyRoc,

But the package was created on 2005 server itself and am running this "RSExecutionLog_Update.dtsx" on my local machine.

My machine has SQL 2005 and SQL 2008 as well. Will this create any problems internally ??



You have to make sure you execute the package with the correct DTEXEC. You have to explicitly select the executable found in 90\DTS\Binn for SQL 2005.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/


P Jones
P Jones
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2808 Visits: 1524
Is your machine at the same patch and service pack level as the server?
Was it saved as encrypt with user key by a different user or login?
raju_6609
raju_6609
SSC Rookie
SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)

Group: General Forum Members
Points: 31 Visits: 75
Hi,

I had same issue. All I did is checked which .net verion is DTExec.exe.config is using and do I have it installed on my machine.

Accordingly I have changed and it worked like charm !

-Regards
Shivraj Biradar



Nik
Nik
SSC-Addicted
SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)

Group: General Forum Members
Points: 404 Visits: 440
Hi all we haver the same problem but we dont have SQL 2008
i get the error

Error 1 Error loading 'PkgETL-SSIS-308_ETLName.dtsx' : 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. . E:\FOLDER NAME\FOLDER NAME_DataSource\308_FOLDER NAME\308_FOLDER NAME\IntSer_308_ETLNAme_ETL\PkgETL-SSIS-308_ETLNAme.dtsx 1 1



BSavoie
BSavoie
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1193 Visits: 795
Hey there CozyRoc, glad I found you!!

I'm in the same boat now. I'm getting this same error message these other folks are. I'm just trying to evaluate the CozyRoc SFTP control. I installed the 32-bit CozyRoc SFTP control, I created a new project, dropped the SFTP task on the control flow, created a new ssh connection that connects just fine, configured the task, and get the same error you guys are getting.

I'm running Windows 7 /64-bit OS. I have both SQL2K5 32-bit and SQL2K8 32-bit installed locally on my development box. I spend most of my time connected to other production/development servers. Either through SSMS, or Remote Desktop. But I like to develop my packages locally, then push them out to production.

So my first question is what determines the version of the CozyRoc SFTP I should use? (32 vs. 64 that is) Is it my OS bits, or my SQL bits?

My second question is how do I tell what version of DTExec the package is trying to execute under?

My last question is does the CozyRoc control give me access to the detailed file transfer session information? I really need to log file transfer session info. You know, "connected", "transferring", "success", "disconnected", etc.

In my role, I'm using quite a few automated apps (inherited, legacy). to move a huge number of files daily over SFTP. I'm trying to get them all consolidate into SSIS tasks. I've been using WS_FTP. It's just not holding up. It's a decent end user tool, but it comes up very short under the pounding I'm giving it. I need a solution with tighter SQL Server integration. I really want to recommend the Company purchase the CozyRoc SFTP control, but I need to be very sure about it first, or I may jepordize my credibility.


Here's the error detail, just in case:

TITLE: Microsoft Visual Studio
------------------------------

Exception deserializing the 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.
".

------------------------------
ADDITIONAL INFORMATION:

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.


------------------------------

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.


------------------------------
BUTTONS:

OK
------------------------------

.
BSavoie
BSavoie
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1193 Visits: 795
I solved this problem by going into Project Properties, Debugging, and setting Run64BitRuntime to false.

I expect since I'm running 64-bit OS, SSIS thinks it should run 64-bit DTExec, but I only have 32-bit SQL Server installed, so that's an incorrect assumption.

Hope this helps someone!

.
anna-marie.barrington
anna-marie.barrington
SSC Rookie
SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)

Group: General Forum Members
Points: 31 Visits: 0
Hello,

could you tell me where to find Project Properties, Debugging and setting Run64BitRuntime to false.

Thanks
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search