{"id":94,"date":"2018-10-11T16:25:48","date_gmt":"2018-10-11T16:25:48","guid":{"rendered":"http:\/\/coding.agust.org\/?p=94"},"modified":"2018-10-11T16:29:09","modified_gmt":"2018-10-11T16:29:09","slug":"odata-for-ssis","status":"publish","type":"post","link":"https:\/\/coding.agust.org\/index.php\/2018\/10\/11\/odata-for-ssis\/","title":{"rendered":"oData for SSIS"},"content":{"rendered":"<p>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 &#8220;ODataSourceForSQLServer2014-amd64.msi&#8221; file.<\/p>\n<p>This means being able for example to pull in data from F&amp;O or SharePoint, directly into a SSIS package.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 &#8220;ODataSourceForSQLServer2014-amd64.msi&#8221; file. This means being able for example to pull in data from F&amp;O or SharePoint, directly into a SSIS package.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13],"tags":[],"class_list":["post-94","post","type-post","status-publish","format-standard","hentry","category-ssis"],"_links":{"self":[{"href":"https:\/\/coding.agust.org\/index.php\/wp-json\/wp\/v2\/posts\/94","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/coding.agust.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/coding.agust.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/coding.agust.org\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/coding.agust.org\/index.php\/wp-json\/wp\/v2\/comments?post=94"}],"version-history":[{"count":2,"href":"https:\/\/coding.agust.org\/index.php\/wp-json\/wp\/v2\/posts\/94\/revisions"}],"predecessor-version":[{"id":96,"href":"https:\/\/coding.agust.org\/index.php\/wp-json\/wp\/v2\/posts\/94\/revisions\/96"}],"wp:attachment":[{"href":"https:\/\/coding.agust.org\/index.php\/wp-json\/wp\/v2\/media?parent=94"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/coding.agust.org\/index.php\/wp-json\/wp\/v2\/categories?post=94"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/coding.agust.org\/index.php\/wp-json\/wp\/v2\/tags?post=94"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}