Error calling remote SSIS from SQL Agent

Jun 28, 2010 at 6:15 AM
Edited Jun 28, 2010 at 7:09 AM

Hi all,

I have a SQL 2008 SP1 x64 Database server with 2008 SP1 x86 SSIS running on an Application server.

One of my developers has creates an SSIS package which uses the SharepointListAdapters assembly. 

When he executes the package on the app server it runs fine, but when I execute the package from a job on the database server i get the following errors:

Microsoft (R) SQL Server Execute Package Utility
Version 10.0.2531.0 for 64-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

Started:  2:40:31 PM
Error: 2010-06-28 14:40:31.70
   Code: 0xC00490F7
   Source: Portfolio Import Portfolio Import (SharePoint List Source [1930])
   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: 2010-06-28 14:40:31.70
   Code: 0xC0047067
   Source: Portfolio Import Portfolio Import (SSIS.Pipeline)
   Description: The "component "SharePoint List Source" (1930)" failed to cache the component metadata object and returned error code 0x80131600.
End Error
Error: 2010-06-28 14:40:31.70
   Code: 0xC004706C
   Source: Portfolio Import Portfolio Import (SSIS.Pipeline)
   Description: Component "component "SharePoint List Source" (1930)" could not be created and returned error code 0xC0047067. Make sure that the component is registered correctly.
End Error
Error: 2010-06-28 14:40:31.71
   Code: 0xC0048021
   Source: Portfolio Import Portfolio Import (SharePoint List Source [1930])
   Description: The component is missing, not registered, not upgradeable, or missing required interfaces. The contact information for this component is "".
End Error
Error: 2010-06-28 14:40:31.71
   Code: 0xC004801F
   Source: Portfolio Import Portfolio Import (SSIS.Pipeline)
   Description: The component metadata for "component "SharePoint List Source" (1930)" could not be upgraded to the newer version of the component. The PerformUpgrade method failed.
End Error

 

Does anyone have any idea how I can resolve this?

 

Thanks

 

Clint