none
can connect using filezilla, but cannot connect using sFTP

    Question

  • i have username, password and
    hostname as https://myftp.abc.com

    I am able to connect using filezilla with these details
    username, password and host as ftps://myftp.abc.com and i don't enter any port number
     If i enter the port number, i cannot connect

    i have used the sFTP component from here http://ssissftp.codeplex.com/
    and i have tried to connect using the username, password and i tried both https://myftp.abc.com and i tried with sftp://myftp.abc.com and i am not able to connect.

    Even though i remove the port number from the properties of sFTP, i still get back the number 22 while running that component

    i get the error

    [SSISSFTTask] Error: Error : timeout: socket is not established. Please check your username, password or port

    Eagerly waiting for your inputs


    Thanks


    • Edited by Jack Nolan Tuesday, May 21, 2013 1:49 PM error code
    Tuesday, May 21, 2013 1:47 PM

Answers

All replies

  • Hi Jack,

    What is the exact error message that you get when you try to connect?

    Keep in mind the component you are trying uses buggy and not very stable backend. How do I know that? We have tried using it in the past and we simply decided it is not worth the effort to make it work properly.


    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    Tuesday, May 21, 2013 1:52 PM
  • https://myftp.abc.com should listen on 443 (but it's not a hard rule), it is best to check with the person in charge or whoever set the site up.

    If in doubt check against http://brainmeta.com/forum/index.php?showtopic=9800

    PS: FileZilla is a Swiss Knife like tool that is able to connect to a waste majority of file transports, don't expect every other free tool to connect to everything.


    Arthur My Blog

    Tuesday, May 21, 2013 1:52 PM
  • Jack,

    Arthur is actually correct. The site you are trying to connect doesn't look like SFTP server at all. This looks like HTTP server. If you are trying to download a file from it, you have to implement a script . Check the script here for reference what needs to be done.


    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    Tuesday, May 21, 2013 1:55 PM
  • Hello CozyRoc,

    I did not go with this initially because i thought it was not free
    is this free? do we need to pay for using that script? and do we need to pay for using the dll of yours


    Thanks

    Tuesday, May 21, 2013 2:12 PM
  • Hello CozyRoc,

    I did not go with this initially because i thought it was not free
    is this free? do we need to pay for using that script? and do we need to pay for using the dll of yours


    Thanks

    The script is free and doesn't require any COZYROC dll. However you have modify the script to remove the dependency on the COZYROC libraries, which are used for showing the user interface.

    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    Tuesday, May 21, 2013 2:18 PM