I am transfering a large file ~500MB from one server to another via a FTP Task inside of a SQL Server 2000 DTS package. During execution I can see the destination file growing however at varying times the FTP task stops and eventually fails. I'm wondering is there a file size limit for this type of task or is there a time limit on how quickly the file has to me moved over? Using a FTP stand-alone program the file usually takes 1hr40min to transfer however even the stand-alone program doesn't always transfer the entire file without erroring out. Could there be a setting on my FTP server that I am missing?
Windows 2003 Server --> Windows 2003 Server
transferring ~500MB text file