Re: Loading data from multiple files

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Sun, 6 Mar 2005 07:23:46 -0500
Message-ID: <qfidncDTPrvIa7ffRVn-uA_at_comcast.com>


<Peter_Jonson22_at_yahoo.co.uk> wrote in message news:1110110331.468485.74240_at_z14g2000cwz.googlegroups.com...
> Hi.
>
> I have to load data from our order processig system into the
> Datawarehouse.
>
> File name format is dataDDMMYYYY.txt for example
> data01012005.txt etc.
>
> Is there any way to specify a mask wnen i want to reload data for
> specific month or year?
>
> Peter
>

SQL Loader?

If OS command line wildcards won't do it for you, try shell scripting or windows host scripting to generate the load scripts and commands.

++ mcs Received on Sun Mar 06 2005 - 13:23:46 CET

Original text of this message