Please start any new threads on our new site at https://forums.sqlteam.com. 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 

vitthala
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 -