I find the proposed solution to be very applicable to a current client project. Please share any thoughts on how I might refine our technical approach. All work will be done in VS2015 with latest AJAX UI (web forms or Azure web apps) talking to Azure SQL DB.
Current process: (1) obtain client data in Excel CSV format, (2) stage to Access 2016, (3) map incoming fields to standard DW schema, (4) run append query against ODBC link to the table in Azure, pushing local staging table to cloud, (5) do BI stuff
(1) obtain client date in Excel CSV format
(2) use Upload control to copy file into Azure Blob Storage
(3) read XLS file row by row, re-map according to DW business logic, followed by SQL insert, i.e. using slightly modified code from sample DataBaseProvider (a great learning example!)