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