Truckin (3/31/2009)
Suggestion 3.The script putting the file onto the server should copy to a separate folder and after the copy completes, should use a 'rename' command run on the target server to 'move' the file into the target folder after file copy.
It is unlikely for a Rename command to be swapped out during execution, when ssis goes to pickup the file it will be completely written.
I agree with the above statement 100 percent. The safest way to work with large data files is to copy them to a staging directory and then execute a move to the directory being polled by the package. I have never once had a contention or timing issue processing files in this manner and doing so removes the need for most of the other overhead.