Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: FTP and SQL*Load scripts
There are probably other ways of doing this, but I would look at using
Perl with the Oracle database interface. You could create a perl script
that is run as a NT service that would do the ftp for you. Then you can
use perl to call sql*loader and load the appropriate file.
Mike
Michael Rothwell wrote:
> I need to be able to, on a daily basis, download any new files from an
> FTP site then start a SQL*Loader session to load the data from those
> files. It is generally only one file per day.
>
> This is on NT 4.0 - any solutions would be greatly appreciated.
>
> Thanks.
>
> Michael.
Received on Tue Mar 07 2000 - 09:01:00 CST