FTP Task - Cannot open data connection (10060)

Discussion in 'microsoft.public.sqlserver.dts' started by Stephen Davies, Jul 28, 2010.

  1. 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
     
    Stephen Davies, Jul 28, 2010
    #1
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.