SQLIS Wiki
User: Guest
Login
Wiki Home Wiki Home
Topic Index Topic Index
Edit Edit
Print View Print View
What's New What's New
Search
RSS 2.0 RSS 2.0
Recent Topics
0xC004801F 0xC004801F
0xC0202022 0xC0202022
0xC0047030 0xC0047030
0xC001404D 0xC001404D
0xC0047071 0xC0047071
0xC0047019 0xC0047019

Current Version:
2/9/2009 8:52 AM Yipi
0xC004801 F
.

The component metadata for "%1!s!" could not be upgraded to the newer version of the component. The PerformUpgrade method failed. The PerformUpgrade method failed.

Constant DTS_E_UPGRADEFAILED
HRESULT 0xC004801F
Error -1073446881
Code 32799
Facility Pipeline (DTS_FACILITY_PIPELINE)
Severity Error (DTS_SEVERITY_ERROR)

Community Notes

We had SSIS packages created on a development machine that displayed this error (and several others) for every component of our packages when we tried to start them on a test server then a deployment server. All machines had SQL Server 2005 SP3 CU1 installed.

Two things fixed the issue for us:

  • Install and run the SSIS service (I do mean the SQL Server Integration Services service)
  • Re-register the dst.dll file via:
 regsvr32 "%ProgramFiles%\Microsoft SQL Server\90\dts\binn\dts.dll" (NON-CLUSTER)

or

 %windir%\syswow64\regsvr32 "%ProgramFiles%\Microsoft SQL Server\90\dts\binn\dts.dll" (CLUSTER)

This fixed the issue on both servers. The order was not important (we mistakenly did it in different order on both servers and it worked anyway).

Below is a sample of the errors/warnings list seen at run-time (all codes were repeated for every single component of the package):

 Started:  1:53:27 PM
 Warning: 2009-02-09 13:53:44.14
    Code: 0xC0048000
    Source: DFT_Insert_Mapping_Data DFT_Insert_Mapping_Data (DTS.Pipeline)
    Description: The registry key "SOFTWARE\Classes\CLSID\{53A228EE-EBFA-48D6-A1AC-5269E5824A2C}\DTSInfo" cannot be opened.
 End Warning
 Warning: 2009-02-09 13:53:44.14
    Code: 0x8004801E
    Source: DFT_Insert_Mapping_Data DFT_Insert_Mapping_Data (DTS.Pipeline)
    Description: Cannot find the "CurrentVersion" value for component {53A228EE-EBFA-48D6-A1AC-5269E5824A2C}. The CurrentVersion value for the component  cannot be located. This error occurs if the component has not set its registry information to contain a CurrentVersion value in the DTSInfo section. This message occurs during component development, or when the component is used in a package, if the component is not registered properly.
 End Warning
 Error: 2009-02-09 13:53:44.17
    Code: 0xC0047067
    Source: DFT_Insert_Mapping_Data DFT_Insert_Mapping_Data (DTS.Pipeline)
    Description: The "component "XML_SRC_" (1)" failed to cache the component metadata object and returned error code 0x80131600.
 End Error
 Error: 2009-02-09 13:53:44.17
    Code: 0xC004706C
    Source: DFT_Insert_Mapping_Data DFT_Insert_Mapping_Data (DTS.Pipeline)
    Description: Component "component "XML_SRC_" (1)" could not be created and returned error code 0xC0047067. Make sure that the component is registered correctly.
 End Error
 Error: 2009-02-09 13:53:44.17
    Code: 0xC0048021
    Source: DFT_Insert_Mapping_Data DFT_Insert_Mapping_Data (XML_SRC_ [1])
    Description: The component is missing, not registered, not upgradeable, or missing required interfaces. The contact information for this component is "Extracts data from an XML data file.;Microsoft Corporation;Microsoft SqlServer v9;  2004 Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;1".
 End Error
 Error: 2009-02-09 13:53:44.17
    Code: 0xC004801F
    Source: DFT_Insert_Mapping_Data DFT_Insert_Mapping_Data (DTS.Pipeline)
    Description: The component metadata for "component "XML_SRC_" (1)" could not be upgraded to the newer version of the component. The PerformUpgrade method failed.
 End Error

Hope it helps,

Yipi.

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

PipelineErrorCodes

Copyright © 2001-2005 SQLDTS.com. All Rights Reserved. TermsOfUse, Powered by FlexWiki 1.8.0.1677