CPackage::LoadFromXML Failure

My current package and all backups of previous packages are giving me this error. Anyone got any ideas? I have 1 GB free disk space. Last OS update a month ago. Ready to reinstall SSIS.

Error 1 Error loading SanDiegoRiverside.dtsx: The connection type "FLATFILE" specified for connection manager "ExtractDenormalizedErrors" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name. c:\visual studio 2005\projects\sandiegoriverside\sandiegoriverside\SanDiegoRiverside.dtsx 1 1

Error 2 Error loading SanDiegoRiverside.dtsx: Error loading value "<DTS:ConnectionManager xmlns:DTS="www.microsoft.com/SqlServer/Dts"><DTS:Property DTS:Name="DelayValidation">0</DTS:Property><DTS:Property DTS:Name="ObjectName">ExtractDenormalizedErrors</DTS:Property><DTS:Property DTS:Name="DTSID">{92AFE6E1-8EA4-4CE5-BDA1-" from node "DTS:ConnectionManager". c:\visual studio 2005\projects\sandiegoriverside\sandiegoriverside\SanDiegoRiverside.dtsx 1 1

Error 3 Error loading 'SanDiegoRiverside.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. . c:\visual studio 2005\projects\sandiegoriverside\sandiegoriverside\SanDiegoRiverside.dtsx 1 1

If you create a new package and then try to create a new connection managers - does it work? If not, the problem might be caused by the issue described in this thread:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=179671&SiteID=1
and the KB:
http://support.microsoft.com/default.aspx?scid=kb;en-us;913817|||

FYI: This was caused by Flash8 Player Installer.

Laurence

|||

We got the same in production tonight, the package have been running fine for 209 nights and have never been changed. Rerunning the package works fine, I can not reproduce the error. We are running Win2003 X64 Ent. + SQL2K5 X64 Ent SP1. SSIS and RDBMS runs on the same box.

I'm not sure I would like re-register any dll's until I know the cause. Any thoughts?

Thanks in advance!

Niklas

Started: 01:13:52 Error: 2007-03-22 01:13:52.67
Code: 0xC0010018
Source:
Description: Error loading value "<DTS:ConnectionManager xmlns:DTS="www.microsoft.com/SqlServer/Dts"><DTS:Property DTS:Name="DelayValidation">0</DTS:Property><DTS:Property DTS:Name="ObjectName">NAV_det</DTS:Property><DTS:Property DTS:Name="DTSID">{C7269043-F2DD-4AE4-A831-C4E5D0632016}</DTS" from node "DTS:ConnectionManager".
End Error
Could not load package "Import_File_To_Table.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:
Started: 01:13:52
Finished: 01:13:52
Elapsed: 0.188 seconds

Microsoft (R) SQL Server Execute Package Utility
Version 9.00.1399.06 for 64-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

|||

I am running into the same issue as LKHall ... I am confused... How come does "This was caused by Flash8 Player Installer" FIX the issue. It does not make sense to me.

Any one knows what is the root cause for this error ?

|||I have unintalled the Flash driver and reboot my PC and I am still running into the package loading failure. Help....|||

The issue seems to be related to DLLs not being registered correctly. When you install new software (the Flash Player, for example) it may register an older or newer version of a DLL, which can can break other applications. Uninstalling may not fix the problem, as that usually does not reverse the changes to the registry.

Instead you may need to re-install the application that is failing, or re-register the DLLs indicated in the articles above.

|||

Thanks John.... Can you please be more specific on what applications (or what DLLs) i need to re-install ? Do you suggest that I need to re-install SQL 2005 again?

I have used the link above to check registry and did not see any wrong registry.

|||Yes, reinstalling SQL 2005 is one way to make sure eveything is set up correctly.|||

Reinstalling SQL 2005 is a good suggestion but any other better ideas ? I have SQL 2005 SP2 installed and reinstalling the entire software is not quite easy....

Plus, I really want to know what is the root cause behind this kind of weird behavior? Doesn't MSFT SSIS team want to know this so that they can fix it in the future SPs?