I will try, but methinks that a lot of "transformation" needs to be done in the interim step. Not all data arrive in a consistent format -- some a text files, others may be .dbf, still others might be other db tables (Oracle or SQL Server). All these factors might limit how much I can use SQL*Loader
--
when small people start casting long shadows, it is time to go to bed