Hi 

Using the OData connector to get data from SharePoint but getting the error below? Not sure what the error is referring to?

Its just this list that is causing the error i can connect to other lists no problem?

I have also tried to only bring back individual columns using the query options which seems to get around the issue but seem unable to return multiple columns (currently using the syntax $select=NPS) but all my column names have spaces in sharepoint so not exactly sure how to reference a column name with spaces using the $select method.

Hope someone can help

• Moved by ArthurZMVP, Moderator Tuesday, September 08, 2015 5:53 PM Does not appear SSIS related
• Moved by Patrick_LiangMicrosoft contingent staff 2 hours 9 minutes ago SSIS issue

Hi,

Thanks for posting in TechNet forum.

This forum is for users discussing issue about SharePoint. Since the issue is more related to the SQL Server Integration Services, I would like to move it to SQL Server Integration Services forum.

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us.

Thanks for your understanding.

Thanks                 

Patrick Liang