Microsoft now has oData available as a datasource for SSIS packages. For my version of SSMS, it meant downloading and installing the SQL 2014 feature pack “ODataSourceForSQLServer2014-amd64.msi” file.
This means being able for example to pull in data from F&O or SharePoint, directly into a SSIS package.