Thanks Grant.

I did create a virtual network so that all my machines can talk to each other (cloud and oniste). I also tried SSIS, Bits and Azure Queues to transfer data. And it seems direct load using SSIS working the best. You are right regarding adding retry mechanism into our system. Will work on that next....