If you don't need all the configuration options available in the Import and Export Wizard and other tools, you can import a text file into SQL Server by using the Import Flat File Wizard in SQL Server ...

SQL Server Management Studio (SSMS) – Data import and query execution 🛠️ Workflow 📥 Import Data from Excel Load Excel file into SQL Server test database using SSMS import wizard or T-SQL scripts.

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.