Download a file from ftp
544866Dec 12 2006 — edited Dec 12 2006Hi,
I have to update a file everyday.For that I download that file from our ftp server and then I run that file(this file is basically a insert script) as a script on sql prompt.
Now I want to automate this whole work.So may I know how to download a file from ftp server,and open it through EDIT PLUS and then run it on sql prompt.
Plz telme the solution.
Thanks,
Ritesh