FTP Task issue

Hot Topic

using a RMO object in a service ?
sql autoincrement
Transformation script last row
Empty report: displayed on server 1, error on server 2
GUID
Treat two columns as one?
Information/ErrorCode from FireInformation/Error
Left join does not work after SQL 2005 upgrade
Connection closes often
dtexec

SQL Server

Problem with SSIS Transaction...Transaction Scope
Shifting past the interim SQL2K
FTP Task - Delete remote files always fails
Why does the index lock my updates in SQL Server 2005?
Flat File Source issue
temporary table not dropped after user disconnected (SQL2005)
VS2005/SQL Server 2005 Mobile subscribing to SQL Server 2000 publication
SQL Express Minimum Requirements Warning on Windows 2000 Professional???
Copying a cube but using a different data source
Question about paging?

FTP Task issue

The FTP Task I've created fails. It appears to be making the connection initially behind a firewall, but it suddenly switches from port 21 to port 3397. Anyone experience this issue Since my firewall is restricting the connection to just port 21, I can't make a permanent connection.

Answer this question

FTP Task issue

  • Lou Bellman

    FTP use 2 ports for it work - one for control connection (21) and one for data connection (any other, 3397 in your case, but may be other).

  • TLee3

    FTP use 2 ports by design (you can read RFC about it). Control connection used to transport commands and most simple responses, but file data transferred by data connection, which is open and live while particular transfer goes on.

  • srishu

    When a ran a test comparison between the SSIS FTP Task and ftp command line, I only saw this difference when the SSIS FTP Task ran. Is this two-port usage specific to SSIS I'm able to get out past the firewall using the ftp command without errors. I can't with SSIS.

  • kokolulogos

    I ran a check again and did see windows command-line ftp sending the data transfer on port 20. Thanks.

  • MBE

    Your problem is this: FTP normally uses ports 20 & 21. But, if you run in passive mode then the remote server will dynamically allocate a port number to you. So, the trick is to run in ACTIVE mode and then you will always run on ports 20 & 21.

    If you are running on visual basic and I can let you have some source code to do this.



  • FTP Task issue
Answer this question