component is missing, not registered, not upgradeable, or missing required interfaces

Mar 17, 2009 at 9:39 PM

This component is very intriguing for some of the ETL work I have coming up.

I am running this on Server 2008 X64 Sp2V113 (SP2 RC0), with SQL 2008x64, and MOSS x64 SP1

I can register the components in BIDS without problems. The components appear in the toolbox (though I had to move them). Thay also read the columns from the SP list correctly.

From development, everything behaves as I would expect, However, when I try to execute the package (from BIDS), I get the following errors:


Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning.
Error: 0xC0048021 at Data Flow Task, SharePoint List Source [1]: The component is missing, not registered, not upgradeable, or missing required interfaces. The contact information for this component is "".
Error: 0xC0047017 at Data Flow Task, SSIS.Pipeline: component "SharePoint List Source" (1) failed validation and returned error code 0xC0048021.
Error: 0xC004700C at Data Flow Task, SSIS.Pipeline: One or more component failed validation.
Error: 0xC0024107 at Data Flow Task: There were errors during task validation.
SSIS package "Package.dtsx" finished: Failure.
The program '[5780] Package.dtsx: DTS' has exited with code 0 (0x0).

I've tried importing everything, using an imported SQL table and OLE-DB Destination. I've tried importing a single column, by setting all the other columns to <ignore> in the task.

I'd appreciate any ideas from anyone.

Thanks for posting this sample.

Coordinator
Mar 18, 2009 at 6:04 PM
Did you use the MSI Installer? Verify that the needed components are in the GAC.  You should have the SharePointListAdapters v1.0.0.0 in there.

Registering them in BIDS does not actually look at the gac until you execute at debug time. BIDS looks at the program file location where the adapter file is copied to. 

My dev environment is server 2008 x64 as well, so we ar eboth on the same platform.
Mar 18, 2009 at 7:06 PM
Yes, I used SharePointListAdaptersSetup.msi to install. I did check the GAC. I had both SharePointUtility 2.0.0.0 and SharePointListAdapters 1.0.0.0 present. I tried uninstalling and reinstalling after a reboot. Got a slightly different error this time:

Error: 0xC0047062 at Data Flow Task, Data Flow Task (SharePoint List Source [1]): System.ArgumentNullException: Value cannot be null.
Parameter name: culture
   at System.String.ToUpper(CultureInfo culture)
   at Microsoft.Samples.SqlServer.SSIS.SharePointListAdapters.SharePointListSource.FindCustomProperty(String name)
   at Microsoft.Samples.SqlServer.SSIS.SharePointListAdapters.SharePointListSource.PerformUpgrade(Int32 pipelineVersion)
   at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostCheckAndPerformUpgrade(IDTSManagedComponentWrapper100 wrapper, Int32 lPipelineVersion)
Error: 0xC004801F at Data Flow Task, Data Flow Task (SSIS.Pipeline): The component metadata for "component "SharePoint List Source" (1)" could not be upgraded to the newer version of the component. The PerformUpgrade method failed.
SSIS package "Package.dtsx" starting.
Error: 0xC004801F at Data Flow Task, SSIS.Pipeline: The component metadata for "component "SharePoint List Source" (1)" could not be upgraded to the newer version of the component. The PerformUpgrade method failed.
Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning.
Error: 0xC0048021 at Data Flow Task, SharePoint List Source [1]: The component is missing, not registered, not upgradeable, or missing required interfaces. The contact information for this component is "".
Error: 0xC0047017 at Data Flow Task, SSIS.Pipeline: component "SharePoint List Source" (1) failed validation and returned error code 0xC0048021.
Error: 0xC004700C at Data Flow Task, SSIS.Pipeline: One or more component failed validation.
Error: 0xC0024107 at Data Flow Task: There were errors during task validation.
SSIS package "Package.dtsx" finished: Failure.

However, the culture is specified as en-US in advanced editor properties.

Thanks for the reply.
Coordinator
Mar 19, 2009 at 4:13 AM
Well~2c that~27s definitely a different error.~26nbsp~3b I hope it~27s not due to a last minute thing i threw in there to appease FxCop ~3a~29 ~3cbr /~3e ~3cbr /~3e Try removing the component and re-dropping the new one on the surface.~26nbsp~3b The upgrade is kind of wonky if you had the previous version this time around~2c because i made a mistake when i released the previous one.~3cbr /~3e
Mar 19, 2009 at 11:07 AM
Hi

I tryed using the SharePoint List component as well and got the same error massage. I tryed it on diffrent OS and both versions the 2008 and 2005 do through both this error message:

Error: 0xC0047062 at Data Flow Task, Data Flow Task (SharePoint List Source [10]): System.ArgumentNullException: Der Wert darf nicht NULL sein.
Parametername: culture
   bei System.String.ToUpper(CultureInfo culture)
   bei Microsoft.Samples.SqlServer.SSIS.SharePointListAdapters.SharePointListSource.FindCustomProperty(String name)
   bei Microsoft.Samples.SqlServer.SSIS.SharePointListAdapters.SharePointListSource.PerformUpgrade(Int32 pipelineVersion)
   bei Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostCheckAndPerformUpgrade(IDTSManagedComponentWrapper100 wrapper, Int32 lPipelineVersion)
Error: 0xC004801F at Data Flow Task, Data Flow Task (SSIS.Pipeline): The component metadata for "component "SharePoint List Source" (10)" could not be upgraded to the newer version of the component. The PerformUpgrade method failed.
SSIS package "Package.dtsx" starting.
Error: 0xC004801F at Data Flow Task, SSIS.Pipeline: The component metadata for "component "SharePoint List Source" (10)" could not be upgraded to the newer version of the component. The PerformUpgrade method failed.
Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning.
Error: 0xC0048021 at Data Flow Task, SharePoint List Source [10]: The component is missing, not registered, not upgradeable, or missing required interfaces. The contact information for this component is "".
Error: 0xC0047017 at Data Flow Task, SSIS.Pipeline: component "SharePoint List Source" (10) failed validation and returned error code 0xC0048021.
Error: 0xC004700C at Data Flow Task, SSIS.Pipeline: One or more component failed validation.
Error: 0xC0024107 at Data Flow Task: There were errors during task validation.
SSIS package "Package.dtsx" finished: Failure.

Mar 19, 2009 at 11:18 AM
Hi,

i was so lucky to get an older version of the component from a friend and this one works just fine. Would be nice if we can access older compiled versions as well.

Regards

Simon

Mar 19, 2009 at 3:41 PM
Very same error here, using the installer for SQL 2005 (Vista 32-bit, BIDS 2005 SP1, SQL SP3).
The previous version works nicely, apart from the issue with multi-line text fields, which is the reason for me to try the latest.
Mar 19, 2009 at 4:44 PM
As I have upgraded with this new release I have gotten the same as "swinkelstraeter". Im  using  the installer for SQL2005 BIDS2005/XP:

Error    1    Validation error. Data Flow Task: DTS.Pipeline: The component metadata for "component "SharePoint List Source" (23942)" could not be upgraded to the newer version of the component. The PerformUpgrade method failed.   ExportSurveyList.dtsx  
Error    2    Error loading ExportSurveyList.dtsx: System.ArgumentNullException: Value cannot be null.  Parameter name: culture     at System.String.ToUpper(CultureInfo culture)     at Microsoft.Samples.SqlServer.SSIS.SharePointListAdapters.SharePointListSource.FindCustomProperty(String name)     at Microsoft.Samples.SqlServer.SSIS.SharePointListAdapters.SharePointListSource.PerformUpgrade(Int32 pipelineVersion)     at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostCheckAndPerformUpgrade(IDTSManagedComponentWrapper90 wrapper, Int32 lPipelineVersion)    c:\my documents\visual studio 2005\projects\exportsurveylist\exportsurveylist\ExportSurveyList.dtsx    1    1  

GAC shows:
SharePointAdapters of version 1.2005.0.0;  public key token: 933a2c7edf82ac1f
SharePointUtility of version 2.0.0.0, public key token 933a2c7edf82ac1f

Alex




Coordinator
Mar 19, 2009 at 6:01 PM
Found it. Thanks - try again.  Yes, I realize I should make the previous verison available :) The releases are a bit weird since this codeplex project has so many 'sub releases' for each individual package, the pattern has been to update the files for our release. 
Mar 20, 2009 at 9:30 AM
Thanks for your quick respons - since your update its working again.

ragards

simon
Mar 20, 2009 at 3:59 PM
Looks like the most recent post of SharePointListAdaptersSetup.msi fixed whatever problem(s) I was having.

Thanks for the resonsive communication and quick updates.

Very cool tool for SSIS - much cleaner than my previous workaround for SharePoint List Imports.

Regards,

Tom
Nov 23, 2009 at 7:30 PM

I have downloaded and installed the latest version. Everything works fine on the server (Server 2008 X64 (SP2), with SQL 2008x64, and MOSS x64) We can run the package local, we can run the package through SSIS file system, etc.

But when we try to schedule a job through the SQL Server Agent we receive the following errors:

 

Message
Executed as user: TEST\SQL-Agent. Microsoft (R) SQL Server Execute Package Utility  Version 10.0.2531.0 for 32-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  1:08:03 PM  Error: 2009-11-23 13:08:03.62     Code: 0xC00490F7     Source: Data Flow Task Data Flow Task (SharePoint List Source [10])     Description: The managed pipeline component "Microsoft.Samples.SqlServer.SSIS.SharePointListAdapters.SharePointListSource, SharePointListAdapters, Version=1.0.0.0, Culture=neutral, PublicKeyToken=933a2c7edf82ac1f" could not be loaded.  The exception was: Could not load file or assembly 'SharePointListAdapters, Version=1.0.0.0, Culture=neutral, PublicKeyToken=933a2c7edf82ac1f' or one of its dependencies. The system cannot find the file specified..  End Error  Error: 2009-11-23 13:08:03.62     Code: 0xC0047067     Source: Data Flow Task Data Flow Task (SSIS.Pipeline)     Description: The "component "SharePoint List Source" (10)" failed to cache the component metadata object and returned error code 0x80131600.  End Error  Error: 2009-11-23 13:08:03.63     Code: 0xC004706C     Source: Data Flow Task Data Flow Task (SSIS.Pipeline)     Description: Component "component "SharePoint List Source" (10)" could not be created and returned error code 0xC0047067. Make sure that the component is registered correctly.  End Error  Error: 2009-11-23 13:08:03.63     Code: 0xC0048021     Source: Data Flow Task Data Flow Task (SharePoint List Source [10])     Description: The component is missing, not registered, not upgradeable, or missing required interfaces. The contact information for this component is "".  End Error  Error: 2009-11-23 13:08:03.63     Code: 0xC004801F     Source: Data Flow Task Data Flow Task (SSIS.Pipeline)     Description: The component metadata for "component "SharePoint List Source" (10)" could not be upgraded to the newer version of the component. The PerformUpgrade method failed.  End Error  Error: 2009-11-23 13:08:03.66     Code: 0xC004801F     Source: Data Flow Task SSIS.Pipeline     Description: The component metadata for "component "SharePoint List Source" (10)" could not be upgraded to the newer version of the component. The PerformUpgrade method failed.  End Error  Error: 2009-11-23 13:08:03.67     Code: 0xC0048021     Source: Data Flow Task SharePoint List Source [10]     Description: The component is missing, not registered, not upgradeable, or missing required interfaces. The contact information for this component is "".  End Error  Error: 2009-11-23 13:08:03.67     Code: 0xC0047017     Source: Data Flow Task SSIS.Pipeline     Description: component "SharePoint List Source" (10) failed validation and returned error code 0xC0048021.  End Error  Error: 2009-11-23 13:08:03.67     Code: 0xC004700C     Source: Data Flow Task SSIS.Pipeline     Description: One or more component failed validation.  End Error  Error: 2009-11-23 13:08:03.67     Code: 0xC0024107     Source: Data Flow Task      Description: There were errors during task validation.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  1:08:03 PM  Finished: 1:08:03 PM  Elapsed:  0.546 seconds.  The package execution failed.  The step failed.

We have given the USER "TEST\SQL-Agent" Admin rights to the server, etc. but can't get past this error. Does anyone know the cause?

Thanks.

Nov 23, 2009 at 8:55 PM

Nevermind. We figured it out. We were scheduling it on the wrong SQL Server Agent on the database cluster.

Thanks!

Jun 7, 2011 at 9:32 PM

Hi emdc2

can you please tell how you fixed the issue you were having while executing the sql agent job.

Thanks.