FTP Download Task (with Overwrite) doesn't overwrite!!!!!!!!!!

Error with SSIS FTP download task:

How to recreate the error:

Download a file using the task.

Go to the file in Windows Exploder and Open the file in notepad.

Copy the last line of text and paste in a few extra rows at the bottom. So if you had 100 rows, you'll now have 103 rows.

Save the file.

Go back to the task and make sure you have "overwrite destination" set to True.

Execute the task.

Go back to the file and look at the bottom of the file. You'll see the same 3 extra rows you pasted in there.

That is not how it should work if it was supposed to be released like that.

Are there any patches that fix this error?

Ryan

I just confirmed Ryan's observations.

VS 2005 - 8.0.50727.42
SSIS - 9.00.2047.00

This looks like it's fixed and will be available in the next release.

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=126467|||You might want to, in the interim, use a File System task to delete the file before going to the FTP task.

Phil|||

Yep. Got it, thanks!

Appreciate the feedback link. That's cool.