2
Vote

SharePoint List Adapters: Error in Visual Studio 2015/SSDT 2015

description

Hello,
I am getting an error trying to use the SharePoint List Adapters as described. Any help is be greatly appreciated.

Environment:
Visual Studio 2015 with Update 3
SSDT 2015
Installed SharePointListAdapterSetup-Beta-2015-06-25.msi
  1. Create new SSIS package/project targeting SQL Server 2014 or 2012;
  2. Add a Data Flow component;
  3. Attempt to add SharePoint List Source results in the following error.

TITLE: Microsoft Visual Studio

The component could not be added to the Data Flow task.

Could not initialize the component. There is a potential problem in the ProvideComponentProperties method.

ADDITIONAL INFORMATION:

Error at Data Flow Task [SharePoint List Source [1]]: System.InvalidCastException: Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSComponentMetaData100'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{887BD061-82D4-4F06-A222-337D42E7F896}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).
at System.StubHelpers.StubHelpers.GetCOMIPFromRCW(Object objSrc, IntPtr pCPCMD, IntPtr& ppTarget, Boolean& pfNeedsRelease)
at Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSComponentMetaData100.get_CustomPropertyCollection()
at Microsoft.Samples.SqlServer.SSIS.SharePointListAdapters.SharePointListSource.AddUserProperties()
at Microsoft.Samples.SqlServer.SSIS.SharePointListAdapters.SharePointListSource.ProvideComponentProperties()

at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostProvideComponentProperties(IDTSManagedComponentWrapper100 wrapper)

Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSComponentMetaData100'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{887BD061-82D4-4F06-A222-337D42E7F896}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)). (Microsoft.SqlServer.DTSPipelineWrap)

comments

HippyGru wrote Nov 7, 2016 at 3:09 AM

I've got the same issue, anyone come across this and fixed it?

Cheers.

wrote Nov 14, 2016 at 8:22 PM