September 20, 2004 at 7:42 am
I am using SQL 2000 and as far as I know you can only download from an FTP site with the FTP task. My question is: What is out there to send FTP?? Anything in SQL??? We have a VB application that will need to FTP EDI Data to a site. I would like to write (if possible) an SP that will trigger some kind of FTP exe. Any ideas?? Any suggestions are much appreciated! Thanks.
September 20, 2004 at 6:52 pm
you can call ftp using xp_cmdshell
September 21, 2004 at 12:35 am
It's difficult to handle error by using xp_cmdshell. For example, xp_cmdshell wouldn't return any message if the ftp site went down.
If your're familiar with VB Script, I suggest you to make use of DTS and create a ActiveX Script Task by using FTP object and properties.
Or simply you may take this 3rd Party Custom Task: SQLDTS File Transfer Protocol Task
September 21, 2004 at 1:43 pm
Thanks! I have downloaded that FTP task dll and will be implementing it soon. Thanks again!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply