I would actually trust vbs more, because first I have to get a third party program to generate the csv, then I need to fiddle with the file, and then I'd like to push it to the server.

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.

You can use one of two options to insert CSV files: "Bulk Insert," a command that works from the SQL Server Management Studio, or "bcp utility," which you run from a Windows command line prompt.

How to Import From CSV With SSIS. Businesses often have to move data around the way construction companies move dirt. A tool like SSIS, designed to transfer and transform large amounts of data ...