>>Did you consider using DTS on MS SQL Server?
>>
>
>Sure did. Belive it or not, the DTS option was much worse. I installed the VFP OLEDB driver on a quad-processor 800MHz server with 4gb of RAM and RAID5, the DTS job took at least 3 hours. I say "at least" because the DBA in charge stopped it because (1) it took way too long compared to the VFP way and (2) it was diminishing server response significantly.

Try DTS with VFP ODBC driver. It should be much faster.