3
Vote

SSDT 2015

description

This plugin does not appear to install correctly with SSDT.

comments

rashadrivera wrote Sep 12, 2016 at 5:28 PM

This seems to be an issue for me too. The installation went OK, but no add-on in sight. I tried to reset toolbox, manually select the dll, but no luck.

wrote Sep 17, 2016 at 12:40 PM

dkviper wrote Oct 10, 2016 at 7:48 PM

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)

wrote Oct 10, 2016 at 7:48 PM