September 6, 2002 at 9:09 am
I am setting up a DTS which includes the FTP task. The Files appear to be downloading (Checking the Destination directory indicates that the file is there and increasing in size). Problem is, at the end of the FTP Task, the files are being erased.
Does anyone know how to prevent this.
September 6, 2002 at 10:17 am
Are the files completely downloaded? Does the package complete without an error? It might include the file deletion as part of a rollback if there is an error.
Steve Jones
http://qa.sqlservercentral.com/columnists/sjones
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
September 9, 2002 at 11:47 pm
I foundd the Problem. This Is a / the problem Acknowledged by Microsoft. If the last file downloaded by a FTP task is larger than about 2MB it is deleted. The bug was fixed with service pack 1. The Network adnmionistrator around here should apply the service packs today. Thanks for the response
September 11, 2002 at 12:20 am
The Service Pack has been applied and I am still seeing the same Problem.
The FTP task Downloads the data Then Deletes the last File Downloaded. Please Help. FTPing Files is critical to core functionality around here.
September 19, 2002 at 8:09 am
We were having the same problem with large files. Finally gave up and just call a batch file that starts FTP with the -s parameter. This allows the ftp commands to be read from a file.
September 25, 2002 at 7:03 am
I used the same solution of creating a command .txt file with all the ftp commands and a .bat file to call ftp with the -s parameter. Easy and very effective. Thanks for the reply
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply