SSIS FTP Task does not work

  • I have encountered a problem where the SSIS FTP Task does not work. The problem is happening in the designer. I am not sure if it would work on the actual server. The "Test Connection" give an error about either the server name or credentials being incorrect. As a work around I used a process task to call out to the http://FTP.exe that is built in to windows. This worked with no issues. I searched Google and microsoft sites and could not seem to find answers.

  • Try to change the port because the default port is 21 and aslo try to test connection in active and passive mode.

  • I tried both active and passive mode. Neither worked. What port number would you suggest? What is the default for http://FTP.exe? I know it works.

    Michael

  • The default port is al;ways 21, We do not use the port while ftping from command prompt.

    Download FTP client to test your connection again, probably if you get the same error then you will know what the problem is. 🙂

  • That is the thing the http://FTP.exe client is working fine. If it is connecting on port 21 then the default ought to work on the built in SSIS FTP Task.

    I just can't get the built in FTP Task to connect. Same sever same port and same ID info. The strange thing is no one else seems to have this problem.

    Michael

  • I have a similar issue. I and working with a development ftp server which does not use a port number and this works fine in command line and "test conenction" in BIDs but the task doesn't execute. It seems the task requires a port number spec and I don't want to use one.

    Frustrating.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply