Re: FTP and SQL*Load scripts

From: Mike Shoop <mshoop_at_iname.com>
Date: Tue, 07 Mar 2000 10:01:00 -0500
Message-ID: <38C519AC.86D59BDD@iname.com>

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