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.

To extract data using SQL from CSV files, you need to import or load the CSV file into a SQL database or a SQL-compatible tool, such as SQLite, MySQL, PostgreSQL, or SQL Server.

This SQL Server Export-Import Utility enables fast and efficient data transfer between SQL Server instances. It allows you to export data from any SQL Server table based on specific selection criteria ...

SUNNYVALE, USA: Novixys Software, Inc. has released Exult for SQL Server v. 1.1, an easy to use Windows application that helps database administrators to import XML files into a Microsoft SQL ...