Click here to Skip to main content
15,559,155 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I wish to download ..connect to SharePoint .aspx and download the SharePoint data as a connection to a oldb connection to a SQL server table

I am using visual studio 2010 and SQL server 2012.

Odata driver does not work

Any ideas team or tutorials

New to SSIS

Please help

What I have tried:

Odata driver from Microsoft and no joy
Updated 14-Jun-19 7:29am
Richard MacCutchan 14-Jun-19 11:15am    
"does not work"
Please edit your question and explain exactly what that means. No one can help until they know what the problem is.
Joanna Webster 14-Jun-19 12:31pm    
When you use it it says xml needs to be set to parse and I can't see the setting any where

1 solution

Microsoft provide a tutorial on how to use the OData Source - Tutorial: Using the OData Source - SQL Server Integration Services (SSIS) | Microsoft Docs[^]
There are other tutorials easily found with a little research e.g. Using the OData Source in SQL Server Integration Services[^]
That last one has an interesting comment
First of all you need to download the component, which is available for both SQL Server 2012 and 2014.
So it definitely works with SQL Server 2012.

Which leaves your
I am using visual studio 2010 and SQL server 2012
Is that genuinely "SQL Server 2012" or is it "SQL Server Express 2012"? (I only ask because of the Visual Studio bit rather than referring to SSMS). If so then SSIS does not come with, which could explain why it's not working.

Failing that, try re-installing the OData driver according to the instructions on the links above.

You also said
New to SSIS
Microsoft also provide SSIS Tutorials which start at
Lesson 1: Create a project and basic package with SSIS - SQL Server Integration Services (SSIS) | Microsoft Docs[^]. Unfortunately, the tutorial only covers from 2014 onwards but the basics are the same.
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900