SSIS Sharepoint List adapter for SQL server 64 bit NOT working

Apr 28, 2014 at 6:34 AM
Need a suggestions in MSBI 2005 and SharePoint 2007 front as one of our live application down with compatibility issues between SSIS SharePoint List Adapter for SQL server 2005 and SSIS 2005.
Technology used : Database –SQL Server 2005 with SP3(64 bit), ETL-SSIS 2005,Reports- SSRS 2005 , Front end – Moss 2007 . All the SSRS reports integrated with MOSS,OS-Windows server 2003(64 bit) .Issue Description:
SSIS 2005 packages pulling data from difference sources (like SharePoint List & XML)
-> One of MSBI application down and are troubleshooting the issue. Have used a tool -SSIS SharePoint List adapter for SQL server 2005 64 bit and this adapter will act as bridge when we will pull the data from SharePoint- List to SQL Server database.
-> Post OS crash, we have reinstalled this software component (SSIS SharePoint List adapter for SQL server 2005 64 bit ) however it’s not working now and failed with compatibility issues between SSIS and current version of SSIS SharePoint List adapter for SQL server 2005 64 bit component.(Error attached)

Have found very limited articles on this issues in MSDN/other MS related websites. Requesting help/suggestion on this issue. Thanks in advance

Error which I am getting :

Error 1 Error loading Ssis.PQDM_DWH.T.List_FileMaintance.dtsx: The "component "SharePoint List File Maintenance" (1)" failed to cache the component metadata object and returned error code 0x80131600. d:\Integration Services Project\Ssis.PQDM_DWH.T.List_FileMaintance.dtsx 1 1

Error 2 Error loading Ssis.PQDM_DWH.T.List_FileMaintance.dtsx: Component "component "SharePoint List File Maintenance" (1)" could not be created and returned error code 0xC0047067. Make sure that the component is registered correctly. d:\Integration Services Project\Ssis.PQDM_DWH.T.List_FileMaintance.dtsx 1 1

Error 3 Error loading Ssis.PQDM_DWH.T.List_FileMaintance.dtsx: The component metadata for "component "SharePoint List File Maintenance" (1)" could not be upgraded to the newer version of the component. The PerformUpgrade method failed. d:\Integration Services Project\Ssis.PQDM_DWH.T.List_FileMaintance.dtsx 1 1