I ran a test over the past week. I created a duplicate connection only this one writes to a file on the engine and then I use a CRON to move the entire file at once to the FTP server once a day.
Results: Each day the file that was being written to the FTP server a record at a time lost some data while the file written on the engine and then FTP’d all at once, never lost data.
The FTP server software on the FTP side is just what came with MS 2000 lite (must I say more?). Moral of the story is to save our data on the engine and then FTP the entire file with a CRON if you want it all to get there.
Thanks for everyone’s help.
Jim
