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
Quote:
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
Quote:
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
Quote:
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.