Error deploying a package containing a custom SSIS component
I have a package that contains a custom SSIS component. The package runs great on my development PC, but when I try to deploy it to my DEV or QA boxes I get the same error message. The message is listed in full below. The custom component does have dependence on an assembly, and I have copied that assembly into the GAC on the server, still no go. I'm hoping somebody can shine some light on this. My take on this is that I must be missing a step in my deployment process, I just can't figure out what it is. =================================== Package "C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Packages\Active Directory Update\Address Book AD Update (no manager).dtsx" could not be loaded. The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.". This occurs when CPackage::LoadFromXML fails. Package "C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Packages\Active Directory Update\Address Book AD Update.dtsx" could not be loaded. The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.". This occurs when CPackage::LoadFromXML fails. (Package Installation Wizard) =================================== The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.". This occurs when CPackage::LoadFromXML fails. ------------------------------ Program Location: at Microsoft.SqlServer.Dts.Runtime.Application.LoadPackage(String fileName, IDTSEvents events, Boolean loadNeutral) at Microsoft.SqlServer.Dts.Runtime.Application.LoadPackage(String fileName, IDTSEvents events) at Microsoft.SqlServer.Dts.Deployment.DtsInstaller.InstallPackagesToFileSystem(WizardInputs wizardInputs) =================================== The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.". This occurs when CPackage::LoadFromXML fails. ------------------------------ Program Location: at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.LoadPackage(String FileName, Boolean loadNeutral, IDTSEvents100 pEvents) at Microsoft.SqlServer.Dts.Runtime.Application.LoadPackage(String fileName, IDTSEvents events, Boolean loadNeutral) There is 10 types of people in the world, those that understand binary, and those that don't.
April 25th, 2011 1:56pm

I think the dependency DLL at this point is red herring (false positive). Rather look at some sort of versioning differences. E.g. it could be the SSIS version or SP. Please also see this post: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/34366c41-211d-4ad9-a495-956bac3ba3df/ to rule out those KBs in the proposed answer are not applicable.Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
April 25th, 2011 2:07pm

In order to deploy a custom component to another server, the component DLL must be installed in the GAC, and also be copied to the C:\Program Files (x86)\Microsoft SQL Server\100\DTS\PipelineComponents folder AND the C:\Program Files\Microsoft SQL Server\100\DTS\PipelineComponents folder. Any DLLs it uses must be GACed (but it's not necessary to place those dependencies in the PipelineComponents folder). Talk to me now on
April 25th, 2011 8:19pm

Thanks for all the input, but I'm still no closer to getting my issue solved. The issue is only with this one specific component. I have other custom components that deploy just fine, this one fails. I have GACed all DLLs that it's using and put everything into the respective folders as Todd mentioned, but I keep on getting that same error mesage. Is there anything else I can try to narrow down that the issue is? Is that error message any indication of what possibly is wrong? Here is the message again.. =================================== Package "C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Packages\Active Directory Update\Address Book AD Update (no manager).dtsx" could not be loaded. The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.". This occurs when CPackage::LoadFromXML fails. (Package Installation Wizard) =================================== The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.". This occurs when CPackage::LoadFromXML fails. ------------------------------ Program Location: at Microsoft.SqlServer.Dts.Runtime.Application.LoadPackage(String fileName, IDTSEvents events, Boolean loadNeutral) at Microsoft.SqlServer.Dts.Runtime.Application.LoadPackage(String fileName, IDTSEvents events) at Microsoft.SqlServer.Dts.Deployment.DtsInstaller.InstallPackagesToFileSystem(WizardInputs wizardInputs) =================================== The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.". This occurs when CPackage::LoadFromXML fails. ------------------------------ Program Location: at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.LoadPackage(String FileName, Boolean loadNeutral, IDTSEvents100 pEvents) at Microsoft.SqlServer.Dts.Runtime.Application.LoadPackage(String fileName, IDTSEvents events, Boolean loadNeutral) There is 10 types of people in the world, those that understand binary, and those that don't.
Free Windows Admin Tool Kit Click here and download it now
April 26th, 2011 9:57am

I have struggled with this issue for too long. I will chalk this up to the custom component we have in place. I will monitor this thread for any input, but I'm switching over from SSIS to powershell to solve this issue.There is 10 types of people in the world, those that understand binary, and those that don't.
April 27th, 2011 10:16am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics