Post reply

Problem with FTP Task on SSIS in SQL2005

  • May 9, 2006 at 1:33 am

    #172435

    Hi, I wonder if anyone can solve my FTP Task problem?

    • I have established an FTP connection to my remote FTP server.  When I test the connection in the connection manager it works fine.  When I close and reopen the FTP connection editor the user name is shown correctly, but I havce to re-enter my password to test the connection again;
    • I establish an FTP Task using the same FTP connection manager, set the operation to 'Receive files' , set IsRemotePathVariable to 'false', set the RemotePath to '/TRGL.TXT', which is the name of my text file in the root directory of the FTP server;
    • I have made a File connection manager which points to an 'Existing folder' being the c:\ drive on my local computer, set the IsLocalPathVariable in the FTP task editor to 'False', referenced LocalPath to the File connection manager and set OverWriteFileAtDest to 'True'.

    When I execute the task I get the error message:

    [FTP task error]: File represented by "/TRGL.TXT" does not exist. 

    and I can't see any files in the '/' directory when I browse the FTP server using the elipses in for RemotePath in the FTP Task editor. 

    But, I can run http://FTP.exe at the command prompt using:

     ftp> get /TRGL.TXT c:\TRGL.TXT  

    without any problems, and I can do the FTP in SSIS using the Execute Process Task, with the same logon, password and parameters, with out problem either.

    I'm stumped.  Does anyone know if I have made a silly error, or is this a known problem?

    Many thanks

  • May 9, 2006 at 11:53 am

    #636833

    Repost this to the correct forum if you want help.  This is the SQL 2000 Newbies forum.

  • September 30, 2006 at 2:25 pm

    #663505

    Im having the same problem.

    If you found an answer please post a link

Viewing 3 posts - 1 through 2 (of 2 total)

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