0xC0047067
Last changed: Tihomir

.

The "%1!s!" failed to cache the component metadata object and returned error code 0x%2!8.8X!. A component failed its put_ComponentMetaData call.

Constant DTS_E_INDIVIDUALPUTCOMPONENTMETADATAFAILED
HRESULT 0xC0047067
Error -1073450905
Code 28775
Facility Pipeline (DTS_FACILITY_PIPELINE)
Severity Error (DTS_SEVERITY_ERROR)

Community Notes

This error is often seen when a component has not been installed on the current machine. An example of this error is shown below,

where a package that uses the Checksum Transformation, built on a second machine, has been copies to a new machine without the component.

This is error is for Data Flow components only, and can be rectified by installed the required component on the local machine.

 Validation error. Data Flow Task: DTS.Pipeline: 
  The component metadata for "component "Checksum Transformation" (270)" could not be upgraded to the newer version of the component. 
  The PerformUpgrade method failed.


 Error loading MyPackage.dtsx: 
  The "component "Checksum Transformation" (270)" failed to cache the component metadata object and returned error code 0x80131600.


 Error loading MyPackage.dtsx: 
  Component "component "Checksum Transformation" (270)" could not be created and returned error code 0xC0047067. 
  Make sure that the component is registered correctly.

==> well, I got the same error, but the component is being built and tested on the same machine... There must be something else as well!

I removed the component from my ssis package and from the toolbox(!), saved the package and closed the ssis package solution.

Then, I rebuilt my SSIS Data flow component, reinstalled and reregistered it (gacutil etc).

In the next step, I reopened my SSIS Package solution, and edited my data flow task. There, I reinserted my (newly registered) task component

into the toolbar and used it from the toolbar to insert it into my data flow task.

Then, I rebuild my package and it worked.

Note This process took me several attempts, but after some trials and errors it worked.

Add your experiences and workarounds here. If you have solved this issue, why not help the next person?

PipelineErrorCodes