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
0x8004801E 0x8004801E
0xC0047010 0xC0047010

Current Version:
2/9/2009 8:51 AM Yipi
0x8004801E
.

Cannot find the "%1!s!" value for component %2!s!. 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. Could not find the CurrentVersion value for component {c200e360-38c5-11ce-ae62-08002b2b79ef}.

Constant DTS_W_COULDNOTFINDCURRENTVERSION
HRESULT 0x8004801E
Error -2147188706
Code 32798
Facility Pipeline (DTS_FACILITY_PIPELINE)
Severity Warning (DTS_SEVERITY_WARNING)

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