June 17, 2009 at 11:58 pm
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 "
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 "
June 18, 2009 at 6:50 am
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.".
June 18, 2009 at 10:39 pm
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 "
June 18, 2009 at 10:43 pm
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.
June 19, 2009 at 1:10 am
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?
January 25, 2010 at 10:11 am
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
February 1, 2010 at 9:26 am
Hi all we haver the same problem but we dont have SQL 2008
i get the error
Error1Error 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.dtsx11
February 28, 2010 at 12:25 pm
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
------------------------------
.
February 28, 2010 at 12:32 pm
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!
.
August 4, 2010 at 5:50 am
Hello,
could you tell me where to find Project Properties, Debugging and setting Run64BitRuntime to false.
Thanks
August 16, 2010 at 4:06 pm
Guys, I had same issue. Here is the solutions...
What you need to do to isolate the problem is go to your SQL Server 2005 binn directory and rename your DTExec.exe to DTExec.exe_Backup. Try running same statement again if it works then you know what your problem is. Your problem is when you execute xp_cmdshell SQL automatically runs in SQL 2005 version instead of using DTExec.exe from SQL 2008 directory. If you don't have other BAT files running using DTExec.exe from 2005 then just leave it renamed and off you go. Otherwise you will have to make sure to convert all BAT file to start from SQL 2008 directories.
Hope this help...
September 21, 2010 at 12:31 am
Hi everybody,
i'm also facing the same problem . i scheduled the job but its getting failure everyday . today i found the reason for failure i pasted the Error Message below . if anybody came across the same problem pls help me to resolve it .
TITLE: SSIS Execution Properties
------------------------------
Failed to open package file "D:\BI_AR\BI_AR\BI_AR.dtsx" due to error 0x80070003 "The system cannot find the path specified.". This happens when loading a package and the file cannot be opened or loaded correctly into the XML document. This can be the result of either providing an incorrect file name was specified when calling LoadPackage or the XML file was specified and has an incorrect format.
({1192850D-1670-405C-BBC3-68431D4936FE})
------------------------------
ADDITIONAL INFORMATION:
Failed to open package file "D:\BI_AR\BI_AR\BI_AR.dtsx" due to error 0x80070003 "The system cannot find the path specified.". This happens when loading a package and the file cannot be opened or loaded correctly into the XML document. This can be the result of either providing an incorrect file name was specified when calling LoadPackage or the XML file was specified and has an incorrect format.
({1192850D-1670-405C-BBC3-68431D4936FE})
Regards,
Sabarinathan
March 16, 2011 at 7:30 am
I was having the same\similar error and it turned out to be a mistake on my part.
So we have a SQL 2005 box that holds our SSIS. I had exported the files and opened them in Visual Studio 2008 to make changes. When I tried to reimport them I was getting the errors reports.
Resolution....
Reexport the SSIS, open and modify them in Visual Studio 2005, then everything worked.
This might not solve your problem, but it was the cause of mine.
March 16, 2011 at 1:09 pm
I am receiving the same error (Error loading 'Package.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.) when attempting to either open my SSIS 2005 package in BIDS 2005 on my testing server.
My configuration: Windows Server 2003 Standard x64 SP 2 with SQL Server 2005 Standard SP2
What I tried:
1. Got C# code from MS Support that checks registry entries under CLSID for incorrect permissions - passed
2. Checked .Net version in DTEXEC.exe.config and installed on machine - same
3. Changed Run64BitRuntime to FALSE in Project Properties
4. Ran %windir%\syswow64\regsvr32 "%ProgramFiles(x86)%\Microsoft SQL Server\90\dts\binn\MsDtsSrvrUtil.dll and %windir%\syswow64\regsvr32 "%ProgramFiles(x86)%\Microsoft SQL Server\90\dts\binn\dts.dll" on server to ensure these were registered properly.
I am still unable to either load in VS or run from command line with DTEXEC utility. I have exactly the same configuration (well obviously not, but it appears to be) on my Production box and it works fine. We had to reload SQL Server a while back and I had to add SSIS on after the fact since my IT folks forgot that.
Please let me know if you need more information. This needs to be fixed as we run several DTSX packages on our test box before moving to Production and are unable to do so since the reinstall.
Thanks,
Scott
May 12, 2011 at 4:38 am
Viewing 15 posts - 1 through 15 (of 28 total)
You must be logged in to reply to this topic. Login to reply