Why doesn't SSIS ftp task receive file?

I'm running an FTP task inside of SSIS to receive a file and the task executes successfully yet no file is returned to the local folder that I specified. Where did the file go? How can I m开发者_如何学运维ake the FTP task download a file to the location that I need it at?

Make sure you have the FTP connection Manager and File Manager set up, and other stuff correct as per the list here (MSDN)

• operation
• "OverwriteFileAtDestination"
• IsASCIITransfer

I've had this problem when I first used an FTP task, but can't recall exactly what I had to do. Double check every setting and also make sure a plain old command line FTP works too to ensure it's only an SSIS issue

Is it possible you have an expression or variable set up that puts the file in another folder? This might explain why the file is not where you expect it.

Also, check to make certain that you're not pulling from a UNIX/Linux box, as this is a known issue.