Post reply

Script FTP Path Question

  • January 6, 2014 at 4:21 pm

    #286932

    I know this is the wrong forum, but it's the only one I belong to and hope someone knows.

    I am using Script_FTP to copy files from a hosting company to our local server. I don't know how it knows what drive to get the file from since only a partial path is supplied. I don't see any shared folders but somewhere there must be a shortcut or something.

    Here's the little script that runs. In the "get" line, the location of the FULL folder is not specified, although the actual path at the source server is C:\DbDownload\FULL\weekly.rar

    [font="Courier New"]open 111.222.333.444[/font] (source server)

    [font="Courier New"]AdminLogin

    AdminPassWord

    get FULL\weekly.rar C:\baks\Full\weekly.rar [/font] (source path and destination local path)

    [font="Courier New"]quit[/font]

  • January 6, 2014 at 5:17 pm

    #1677913

    I'm not sure exactly what your question is, but will take a shot in the dark.

    When you log in to an FTP server, it has the concept of a "home" directory.

    You do not care where that "home" directory is, which is why you don't specify a "full path" like you would in Windows.

    The FTP server knows the actual local path for your "home" and prepends it to the supplied "relative" path to make a "full" path.

    MM


    select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

  • Forum Etiquette: How to post Reporting Services problems
    • [/url]
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
    • [/url]
  • How to Post Performance Problems - by Gail Shaw
    • [/url]

  • January 6, 2014 at 5:39 pm

    #1677915

    Thanks, I was guessing it was something like that, but I have not found it yet. I assumed it would be on the target server where it runs, while pulling from the source server.

    I want to set up a similar job, and tried using the full path this time but got errors ... maybe syntax.

  • January 6, 2014 at 5:55 pm

    #1677916

    When you're connected to the FTP server, you can change directory using cd, just like in Windows. You'll probably want to use the forward slash, but that's not true 100% of the time. Another thing to consider is that many FTP server connections are case-sensitive when using directories and filenames.

    You can change your local directory using the lcd command.

    HTH

    Tally Tables - Performance Personified
    String Splitting with True Performance
    Best practices on how to ask questions

    • Viewing 4 posts - 1 through 3 (of 3 total)

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