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

  • - Win.

    SSCertifiable

    Points: 6790

    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 "3" from node "DTS:Property".

    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

    One Orange Chip

    Points: 28388

    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.

    SSCertifiable

    Points: 6790

    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

    One Orange Chip

    Points: 28388

    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

    SSChampion

    Points: 12323

    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

    SSC Enthusiast

    Points: 103

    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

    SSC-Addicted

    Points: 492

    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

    SSCertifiable

    Points: 6309

    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

    SSCertifiable

    Points: 6309

    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

    SSC Enthusiast

    Points: 123

    Hello,

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

    Thanks

  • kushalfree99

    SSC Rookie

    Points: 49

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

  • sabarichandru

    SSCommitted

    Points: 1704

    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

  • dkoester@cerner.com

    SSC Enthusiast

    Points: 133

    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.

  • Squatt Gmail

    SSC Veteran

    Points: 268

    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

  • a_k93

    SSC Enthusiast

    Points: 174

Viewing 15 posts - 1 through 15 (of 28 total)

You must be logged in to reply to this topic. Login to reply