SQL2000 has a task in DTS that provides FTP facilities. Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]> wrote :
> Yeah sure...well if it's a hosting company you may not be able to use the > solution I use. I have written a custom DLL which calls the Windows WinInet > API and allows for all kinds of stuff via the Windows API (assuming you are > on Windows!) > > Or you can just use EXEC master..xp_cmdshell and pass in standard command > line FTP commands. > > EXEC master..xp_cmdshell 'FTP OPEN' etc.... > > N > > > > > -----Original Message----- > From: Paul Johnston [mailto:[EMAIL PROTECTED] > > Sent: 14 January 2004 12:18 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] Bulk Insert Into SQL Server DB > > > If you can use FTP you can do it via SQL in a variety of ways. > > An example would be nice. I am not sure that the hosting company has this > setup or not. This may be the best solution, so I may have to ask them. > But as I said... Example? > > Paul > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human > help, e-mail: [EMAIL PROTECTED] > This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, > Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, > Registered in England, Number 678540. It contains information which is > confidential and may also be privileged. It is for the exclusive use of the > intended recipient(s). If you are not the intended recipient(s) please note > that any form of distribution, copying or use of this communication or the > information in it is strictly prohibited and may be unlawful. If you have > received this communication in error please return it to the sender or call > our switchboard on +44 (0) 20 89107910. The opinions expressed within this > communication are not necessarily those expressed by Reed Exhibitions. > Visit our website at http://www.reedexpo.com > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] Steve Powell [EMAIL PROTECTED] 07971 583792 -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
