Use the file manager to locate the CSV file you want import. Select the CSV file with the mouse. Click the "Import" button. Click the "Delimited" radio button in the Text Import Wizard.

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.