Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 SQL Sharepoint Integration thru SSIS using oData

Author  Topic 

Starting Member

1 Post

Posted - 2015-04-22 : 17:13:24
SSIS SP Connection using OData connector. I was able to connect to Sharepoint site fine and was able to see the data thru preview and all.. but when i execute the task i get below error.

[OData Source [2]] Error: The OData Source was unable to process the data. Object reference not set to an instance of an object.

Note: Visual Studio 2012 with BI template not sure how different is that from SSDT 2012. When i go try to open SSDT 2012, i get VS 2010 shell, that's why i use VS 2012 with Business Intelligence template thinking that maybe same as SSDT 2012. If this has to do something with error message i get above.

Task: OData Source with SP connection information OLE DB Destination.

Let me know your thoughts!!

- Advertisement -