Hi,
I have come across this article, https://community.dynamics.com/crm/b/zsoltzombiksblog/archive/2016/02/18/dynamics-crm-integration-tools-ssis. This basically indicates that the SSIS Odata connection is a no go and a third party option is the way to go.

Hi,
The Dynamics server is remotely hosted.