March 2, 2004 at 9:42 pm
Hi folks. I have this problem. I need to upload 2 files from within a DTS package. I've only used the FTP task once, and I didn't know that FTP only works one way (download only). so, the question is, is there a way to upload the data without insalling any third pary tools of COM objects? Any feedback is greatly appreciated.
March 2, 2004 at 11:59 pm
script the ftp upload and call the script from DTS.
March 4, 2004 at 6:19 am
Scripting the upload makes sense, as does calling it through a cmdexec within a dts, this does however have the drawback of not logging that the ftp transfer went without a hitch, you would have to manually examine log files or create a process to do so in order to get this information.
I know that there is a freeware dll out there which does the basic ftp upload and download for you using sp_oacreate and which will allow you to put the ftp process in a stored procedure and can do the error handling aspect. I have a copy, but unfortunately I cannot remember the site which it came from. I'll research and post if I can find it.
March 4, 2004 at 7:38 am
Here's the link... http://www.sqlteam.com/item.asp?ItemID=6002
March 4, 2004 at 6:14 pm
For another option, see proc listed here:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=20&messageid=102069#bm102395
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply