I am attempting to implement the SSIS "FTP Task" within a package "Control
Flow" with some very frustrating results.

I have configured the Connection with "UsePassiveMode" = True and
IsTransferTypeASCII = False since it is a zip file, but always receive
"Cannot open data connection (10060)" (usually a symptom of not being able to
connect back to the client). The firewall on the initiating client machine
is open to all destination ports (logged) with a source port of 20, anything
outside of this that is blocked will be logged as well.

The FTP server log when executing the task looks like:

SSIS FTP Task Connection log
----------------------------
(000924) 23/07/2010 10:01:09 - (not logged in) (x.x.x.x) > USER FCFACCT
(000924) 23/07/2010 10:01:09 - (not logged in) (x.x.x.x) > 331 Password
required for FCFACCT.
(000924) 23/07/2010 10:01:09 - (not logged in) (x.x.x.x) > PASS ********
(000924) 23/07/2010 10:01:09 - FCFACCT (x.x.x.x) > logged in.
(000924) 23/07/2010 10:01:09 - FCFACCT (x.x.x.x) > 230 User FCFACCT logged in.
(000924) 23/07/2010 10:01:09 - FCFACCT (x.x.x.x) > CWD /
(000924) 23/07/2010 10:01:09 - FCFACCT (x.x.x.x) > asked to change directory
: 'C:\temp\FTPTest\ -> C:\temp\FTPTest\' --> Access allowed.
(000924) 23/07/2010 10:01:09 - FCFACCT (x.x.x.x) > 250 CWD command
successful. "/" is current directory.
(000924) 23/07/2010 10:01:09 - FCFACCT (x.x.x.x) > TYPE A
(000924) 23/07/2010 10:01:09 - FCFACCT (x.x.x.x) > 200 Type set to A.
(000924) 23/07/2010 10:01:09 - FCFACCT (x.x.x.x) > PORT x,x,x,x,202,173
(000924) 23/07/2010 10:01:09 - FCFACCT (x.x.x.x) > 200 Port command
successful.
(000924) 23/07/2010 10:01:10 - FCFACCT (x.x.x.x) > LIST
(000924) 23/07/2010 10:01:10 - FCFACCT (x.x.x.x) > 150 Opening data
connection for directory list.
(000924) 23/07/2010 10:01:33 - FCFACCT (x.x.x.x) > 425 Cannot open data
connection (10060).


When I use an FTP client program with the same credentials from the same
machine I get:

Standard FTP Client Connection Log
----------------------------------
(000937) 23/07/2010 12:22:10 - (not logged in) (x.x.x.x) > USER FCFACCT
(000937) 23/07/2010 12:22:10 - (not logged in) (x.x.x.x) > 331 Password
required for FCFACCT.
(000937) 23/07/2010 12:22:10 - (not logged in) (x.x.x.x) > PASS ********
(000937) 23/07/2010 12:22:10 - FCFACCT (x.x.x.x) > logged in.
(000937) 23/07/2010 12:22:10 - FCFACCT (x.x.x.x) > 230 User FCFACCT logged in.
(000937) 23/07/2010 12:22:10 - FCFACCT (x.x.x.x) > PWD
(000937) 23/07/2010 12:22:10 - FCFACCT (x.x.x.x) > 257 "/" is current
directory.
(000937) 23/07/2010 12:22:10 - FCFACCT (x.x.x.x) > FEAT
(000937) 23/07/2010 12:22:10 - FCFACCT (x.x.x.x) > 500 Unknown command.
(000937) 23/07/2010 12:22:10 - FCFACCT (x.x.x.x) > REST 100
(000937) 23/07/2010 12:22:10 - FCFACCT (x.x.x.x) > 350 REST supported. Ready
to resume at byte offset 100.
(000937) 23/07/2010 12:22:11 - FCFACCT (x.x.x.x) > REST 0
(000937) 23/07/2010 12:22:11 - FCFACCT (x.x.x.x) > 350 REST supported. Ready
to resume at byte offset 0.
(000937) 23/07/2010 12:22:11 - FCFACCT (x.x.x.x) > PASV
(000937) 23/07/2010 12:22:11 - FCFACCT (x.x.x.x) > 227 Entering Passive Mode
(y,y,y,y,255,148).
(000937) 23/07/2010 12:22:11 - FCFACCT (x.x.x.x) > LIST
(000937) 23/07/2010 12:22:11 - FCFACCT (x.x.x.x) > 150 Data connection
accepted from x.x.x.x:52346; transfer starting.
(000937) 23/07/2010 12:22:11 - FCFACCT (x.x.x.x) > 226 Transfer ok

Any suggestions on using the FTP task would be much appreciated.

Regards
Stephen Davies