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>
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