My plan was to get the text file and do a Bulk insert into a holder table in Sql server 2000 via the bulk insert command inside a stored procedure.

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.

I am trying obtain some data from a Cache database into a Mysql database using Cache's SQL Gateway.Getting the data out of Cache is easy, but I am not sure about the easiest way to get it into ...

SQL Bulk Insert is not a new technology. In fact, I've used it since SQL Server 6.5., when it was a very cumbersome implementation from Microsoft that required a great deal of preparation of the Bulk ...