Have looked around quite a bit for my precise problem. Haven't found any.
Simple ftp "get" receive files not working in SSIS 2005 and 2008. THe FTP task runs, turns green for success but no files are received. No errors are received.
Works in SQL DTS 2000 and FTP command line.
I can "see" the directory in BIDS, but a receive doesn't work. (either for a single file or wildcard result is the same.
I have many other FTP processes using the FTP Task, this is only one reading from a MS FTP server internally. Please don't tell me the work arounds, as I already know them. I am looking for an answer to the above issue. I am assuming it is a MS bug.
View Complete Post