Custom Data Flow Task throwing error when run from command prompt

Hot Topic

Release of 1.0 product
article row filter - 2 parameters
Security problems in the initial synchronization
SQLCMD to execute all script files in directory?
Migration from SQL 2000 Enterprise Server to the SQL 2005 Enterprise Server (64 bit-Itanium Server)
There's just no escaping it... data containing quotes ruining CSV files
Management Studio - drag table and drop to SQL Editor
Upgrading to SQLServer2005
Want to log CLR exceptions in SQL table
Really need to use this query - but it has a sub-query in it...

SQL Server

Jet.OLEDB.4.0 and Linked Servers (SQL standard 2005 on Win2003 SP1)
EXECUTE master.dbo.xp_delete_file
FormatNumber >> Excel export?
Custom Formatting SQLXML Result
Manuel Identity system
SSIS DTC Transaction's HOT questions
Group by on a concatenate field
Can't uninstall previous version of AdventureWorks database
Problems with the SELECT ROW_NUMBER() OVER approach
Copying database using "Copy Database"

Custom Data Flow Task throwing error when run from command prompt

Hi,

I developed a custom data flow task in .net 2.0 using Visual Studio 2005. I installed it into GAC using GACUTIL and also copied it into the pipeline directory. This task runs absolutely fine when I run it on my local machine both in BIDS and using the script in windows 2000 environment. However, when I deployed this package into a windows 2003 server, the package fails at the custom task level. I checked the GAC in windows\assembly directory and it is present. Also I copied the file into the PipeLine directory and verified that I copied it into the correct pipeline directory by checking the registry. The version of the assembly is still Debug. I looked up documentation in MSDN but there is very little information about the errors I am seeing.

The error I get is pasted below, Can somebody please help me as I am currently stuck and running out of ideas to fix this problem.

Code: 0xC0047067

Source: DFT Raw File DFT Raw File (DTS.Pipeline)

Description: The "component "_" (2546)" failed to cache the component metadata object and returned error code 0x80131600.

Code: 0xC004706C

Source: DFT Raw File DFT Raw File (DTS.Pipeline)

Description: Component "component "_" (2546)" could not be created and returned error code 0xC0047067. Make sure that the component is registered correctly.

Answer this question

Custom Data Flow Task throwing error when run from command prompt

  • yvz

    I don't think you are really trying very hard. Googling the error code 0xC0047067 gives me the direct wiki.sqlis.com page for that error as #1. Included in that page is the following additional information. Quite useful I think, whilst you say you have installed it in the GAC, I'd have step back and think again. Is the package really running on that machine Is it the right version in the GAC Check the package XML or the strong name, why can you not load an assemnbly by the strong name The latter is a pure .Net issue. Any ideas yet

    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.


  • Angel Rom

    This link might help: http://wiki.sqlis.com/default.aspx/SQLISWiki/PipelineErrorCodes.html

    Hint: try searching Google in the future.



  • Peter Ritchie

    Narasimham wrote:

    The Error Code is seen in the link provided by you but their is no solution/notes explained for that error Code

    Thanks

    Narasimham

    There are solution/notes for those error codes in the link that I provided. You need to click on the error codes to see them.

  • Nick Gravelyn

    Narasimham wrote:

    Hi Duane,

    I have checked this link before and their is nothing available for this Error code.

    Thanks

    Narasimham

    The following codes that you previously posted appear on the link that I provided above:

    0xC0047067

    0xC004706C



  • lilshorty

    The Error Code is seen in the link provided by you but their is no solution/notes explained for that error Code

    Thanks

    Narasimham

  • Haoyang

    Hi Duane,

    I have checked this link before and their is nothing available for this Error code.

    Thanks

    Narasimham
  • Custom Data Flow Task throwing error when run from command prompt
Answer this question