Good old FTP and flat file import will do the trick reliably and never take a day off. Here are the basic steps to automate an FTP download in Windows followed by a CSV insert into MS SQL Server.

Not an expert by any means, but by happenstance, today I had to update a C# app I wrote 3 years ago that reads in an Excel file into a SQL Server table. I'll make some assumptions here: Based on ...