Microsoft released the ‘Microsoft® SQL Server® 2014 Feature Pack’:
The Microsoft SQL Server 2014 Feature Pack is a collection of stand-alone packages which provide additional value for Microsoft SQL Server. It includes the latest versions of:
– Tool and components for Microsoft® SQL Server 2014.
– Add-on providers for Microsoft SQL Server 2014
Download it here:
Microsoft® SQL Server® 2014 Feature Pack
Looking for the 2012 version?:
Microsoft® SQL Server® 2012 Feature Pack
The OData Source component for SSIS 2014 is included in the feature pack.
For SSIS 2012 see below:
Microsoft OData Source for SQL Server 2012 provides the capability of consuming OData services to SQL Server 2012 Integration Services (SSIS). Users can use it in an SSIS package to extract data from an OData service and then perform further ETL processing.
The Open Data protocol (OData) lets you access a data source, such as a database, by browsing to a specially constructed URL. This allows for a simplified approach for connecting to and working with data sources that are hosted within an organization.
There are many OData sources available in enterprise and in cloud:
– SharePoint Foundation 2010
– SharePoint Server 2010
– SQL Azure
– Windows Azure Table Storage
– Windows Azure Marketplace
– SQL Server Reporting Services
– Microsoft Dynamics CRM 2011
– Windows Live