November 3, 2008 at 7:24 pm
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.
November 4, 2008 at 7:18 am
Try to change the port because the default port is 21 and aslo try to test connection in active and passive mode.
November 4, 2008 at 7:53 am
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
November 4, 2008 at 8:24 am
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. 🙂
November 5, 2008 at 8:07 am
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
July 13, 2010 at 6:53 am
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