Re: SV: Automatic import of a text file into an Oracle database

Use SqlLoader to populate a staging table then use SPs or other code to check it and take appropriate action.

Or, invest in a good ETL tool ( like Ascential's Data Stage ) to handle the process.

Hth,
John
"Lars Mollerup" <lars.mollerup_at_niva.no> wrote:

>Thanks for your quick response. I am aware of the sqlloader but i want to do
>some extensive checking of the data on the file. Is sqlloader userful in
>this setting?
>
>Lars
>:-))
>konsultant_1 - konsultancIT.pl <konsultant_1_at_konsultancIT.pl> skrev i
>meldingsnyheter:3EEF1579.6000203_at_konsultancIT.pl...
>> Lars Mollerup wrote:
>> > Hello folks!
>> >
>> > here is my question:
>> >
>> > What is the best way to get data from a character delimited text file
>into
>> > an oracle database once a day. It should import it automatically and
>check
>> > the data before inserting values into tables?
>> >
>> > (I am thinking of making a VB program to do this but could it be be
>done by
>> > scheduling a
>> > stored procedure or some other Oracle specific way?)
>> >
>> >
>> > TIA
>> >
>> > Lars Mollerup
>> > NIVA, Norway
>> >
>> >
>>
>> SQLOADER
>>
>> --
>>
>> www.konsultancIT.pl
>> Oracle&MS-SQL consulting
>>
>

----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Received on Tue Jun 17 2003 - 10:08:05 CDT