SQL Server Performance

FTP Upload using DTS

Discussion in 'SQL Server DTS-Related Questions' started by Chappy, May 15, 2003.

  1. Chappy New Member

    What is the recommended way of transferring files from my server to a remote FTP server. I assumed DTS FTP task would allow me to do this, but it appears it is only designed for downloading via FTP. Any suggestions please?
  2. satya Moderator

    True, in this case just use DTS task to output to a flat file.

    _________
    Satya SKJ
  3. Chappy New Member

    Yes, I do, but its the flat file I want to FTP to another location
    Im hoping im not going to have to schedule a dos FTP to do the task, but I suspect I might have to
  4. Argyle New Member

  5. Chappy New Member

    Thanks Argyle!
  6. Chappy New Member

    I have my FTP upload working now, thanks. Now I am faced with the problem that if the server is not responding, dos FTP simply stalls, and the CMD prompt never terminates.
    Im looking for a way to either:

    Supply a timeout value to DOS FTP (not possible afaik)
    Specify a timeout to xp_cmdshell (not possible)
    Specify a timeout for the job as a whole (hmm, maybe possible?! But even so, will that necessarily terminate the child cmdprompt process)

    Failing this, does anyone know a cmdline FTP app that will allow a timeout to be supplied? Thanks, I know this is slightly off topic.
  7. Jacco New Member

    You can set a timeout on either a cmdExec step in a job or a cmdExec task in DTS.

    hth
  8. Chappy New Member

    Hi Jacco, thanks for the info, but after searching both BOL and examining EM interface, I cant find anyway to set this timeout in a job. Could you explain please ?
  9. vbkenya New Member

  10. Chappy New Member

    Thanks for the advice. Im not confident about changing this registry setting on a production server though, mainly because the most frequent reason the ftpo task fails is not due to heavy network usage. Its a clients ftp server, and its not uncommon for them to screw up user accounts, server characteristics etc, which means my user account regularly goes belly up (I dont have to cater for this, all I want to make sure is that I try to send the data, and if it does fail, then it doesnt leave a CMD shell running perpetually on my server).

    Any more ideas from anyone please?
    The only solution I can see is that I write a cmdline based FTP client which does allow a graceful timeout, but It would be nice to avoid this

    Thanks
  11. vbkenya New Member

    If you know some VB and DTS scripting, Try this link:

    http://www.sqldts.com/default.aspx?6,102,251,0,1]

    No guarantees here but it might help. I should state that I haven't tried it yet. Good Luck.



    NHO
  12. Chappy New Member

    Thanks vbkenya, this looks like the most promising solution so far!
  13. vbkenya New Member

    Try it and let us know. I can't confirm it's usefulness now...a bit tied up in some spaghetti T-SQL.

    NHO
  14. gaurav_bindlish New Member

    Chappy, if you want you can also have a look at the examples that are installed with SQL Server installation. Trust me they are very useful. Infact we had developed an VC++ application for import / export of data using DTS by taking guidance from those examples.

    Gaurav

Share This Page