SQL Server Integration Services FTP task not working
Posted on 2015-02-11
I'm trying to insert a FTP task running in SSIS (2012). I'm able to get the ftp connection to work (Hit test connection and it comes back success); however, when I try to run the task (from SSDT/BIDS/Visual Studio--I'm just clicking F5), it sits and spins for about 10 minutes and then fails. The weird thing about this is if I go to the destination folder (on a different server) I can actually see the file come into the directory, but after about 10 seconds, it disappears. I'm thinking a security issue, but I can take the FTP account that I'm using for the SSIS FTP task and using an ftp client (FileZilla) I'm able to upload/download anything I want.
Both systems (host and destination server) are running WIndows Server 2012.