>we pull text files into tables for processing nightly. The text files are downloaded by FTP from various machines. We need to be able to tell when the text files are closed by this process, because our processing can't work on these files until they are completely downloaded.
>
>any ideas?


Dave,

no return code from your ftp application ?

do you now the size of the file before ftp ?
how about checking for the size of the file on the client ?