Results 1 to 4 of 4

Thread: File transfer

  1. #1
    Join Date
    Sep 2003
    Posts
    212

    Unanswered: File transfer

    I have to make a process/stored procedure that will either send or receive from a specific location (parameters: ftp server, username, password, filename, etc). Ne direction/help in order to do this. Or if anyone has done this before please help.
    thx

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Could you supply some more specifics?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Sep 2003
    Posts
    212

    Arrow

    The specifies are:

    I have to make a sp that will send/receive files to/from an ip address or ftp site.
    The sp will query the information such as (filename, send_time, receive/send, servername, usernid, password, size_of_file, etc).
    Once this info is queried, the script should transfer the file to respective location using, either exec xp_cmdshell or ne other way.

    Since it's critical that the file being sent/received, must succesfully be sent/received. The script must also handle that.

    This script will be running on SQL server. Any sample code?
    thx

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    I guess you're going to use ftp...

    OK...build an ftp script...and execute it from a bat file with xp_cmdshell...don't forget to redirect the output...maybe load it to a log table...

    I guess you'll interogate a directory..

    Use xp_cmdshell 'DIR D;\whatever\*.*

    and load that to a table to interogate that...

    something like that?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •