Jaa

Why “Package Load error 0xC0010014 in CPackage::LoadFromXML” error appears while trying to run an SSIS Package ?

  • Artikkeli

As you know an SSIS package is an XML content regardless if you're storing your SSIS package in file system (as a .dtsx file) or storing your SSIS package in MSDB (then your XML content inserted into sysdtspackages or sysdtspackages90 tables in MSDB)

Of course this XML content has its own schema and the SSIS Runtime and BIDS (Business Intelligence Development Studio) needs to parse the content of the XML.

"Package Load error 0xC0010014 in CPackage::LoadFromXML" error message is a generic error message when SSIS Runtime tried to parse the package. There could be various reasons for you to get this error message. But all of them refers to something wrong in your SSIS XML content.

The first thing that I will suggest you to overcome this issue will be minimizing the package step-by-step. I would suggest starting to remove the 3rd party components in the first hand.

Here's a story about this...

One of our customers had experienced this issue. The environment was SQL Server 2008 x64 on a Win2k8 R2 x64 platform. The very first thing that I noticed was a 3rd party connection manager. It was a connection manager helping customer to connect to Oracle. Though we have the needed components coming as out-of-box in SSIS to connect Oracle, customer was preferring this 3rd party connection manager.

The thing that I noticed was the 3rd party connection manager was 32bit though the environment is 64bit. As the BIDS works as 32bit and recognizes 32bit connection manager easily, they would design their packages but it was failing when they tried to run. The problem here was simple their SSIS project was trying to run the package as 64bit which is by default for a 64bit OS. As the 64bit SSIS runtime cannot see 32bit components (including this 3rd party connection manager), it was failing with this CPackage:LoadXML error. This type of cryptic error message is very normal as this is a 3rd party component and the SSIS runtime does not aware of those components there in your package.

The solution for this scenario was asking customer change the debug option "Run64BitRuntime" from True to False as shown in the screenshot below :

 

With this "Run64BitRuntime=False" setting, all works as in 32bit mode.

Another possibility for this error to be appear could be using different DateTime values than the current OS regional settings have. Let's say your current OS shows the datetime as 12/24/2010 but the value in your SSIS package is "24.12.2010" which is a wrong value. Again, to be sure that if that's the reason you can snip out your SSIS datetime values just for testing purposes.

Comments

  • Anonymous
    November 07, 2013
    Had exactly this issue with the Oracle Attunity SSIS connector.  Thanks for posting this.

  • Anonymous
    November 07, 2013
    Happy to hear that it helped Travis :)

  • Anonymous
    February 14, 2014
    I faced the similar issue at my work. This what happened. I am running my package located on a server through a batch file. i got the same error as above Could not load package "G:WHSL_SSISETLWHSL_REPORT_GENERIC.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. But all I did was to change the batch file. Because earlier the Microsoft SQL Server is installed under below location C:Program Files (x86), and my batch file is pointing this, but now it is installed in the following location C:Program Files. After changing the batch file to point to correct location my package worked fine.

  • Anonymous
    April 03, 2014
    Nice post. Unfortunately, this error can also be caused by trying to deploy a package created on a newer-than-deployment-environment version of Visual Studio. Specifically, I have taken a SSIS 2005 package, opened it in VS 2010, and it refuses to deploy back to integration services on SQL Server 2005.

  • Anonymous
    June 11, 2014
    Exact same issue. Very helpful. The user had recently lease rolled desktop and had not installed all the software yet. Installed attunity driver on the desktop experienceing the issue. It opened successfully after the installation of attunity driver. Thanks

  • Anonymous
    July 10, 2014
    Nice post. I have an ancient package using an Oracle connection.  Voila.

  • Anonymous
    August 19, 2014
    That was it.  Once I changed the setting of 64-Bit to False it worked.  Thanks for your help.

  • Anonymous
    August 31, 2014
    I was using the SharePoint Data source control from Pragmatic Works to get access to Lists on a SharePoint site ie their 'Task Factory' product. Your post from 4 years ago just keeps on giving. Thanks Faruk

  • Anonymous
    November 07, 2014
    Thanks a lot

  • Anonymous
    December 18, 2014
    Thank you so much for Run64bitRuntime option. It resolved my XML error by setting to False.

  • Anonymous
    January 19, 2015
    I am getting the similar error when trying to deploy my SSIS project from VS 2012 to SSISDB in SQL 2014. Error output contains something like '...CPackage::LoadFromXML fails...'. Any other possible cause for this?

  • Anonymous
    April 30, 2015
    Thanks for posting this, it saved me from hours of troubleshooting.

  • Anonymous
    September 16, 2015
    You saved my day!

  • Anonymous
    September 16, 2015
    You saved my day!!

  • Anonymous
    September 20, 2015
    Thanks for the article. I was able resolve my issue with your solution. Great work!!

  • Anonymous
    April 07, 2016
    The comment has been removed

  • Anonymous
    April 11, 2016
    Thanks alot and the same problem with oracle attinity drivers.

  • Anonymous
    August 12, 2016
    I fixed thi putting one inferior level in targetserverversion on properties of project