Re: Loading data from multiple files

Peter_Jonson22_at_yahoo.co.uk wrote:
> 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

To see e.g. all files for month 012005 do,

C:\> dir /b data*012005.txt
$ ls -b data*012005.txt

You can script it any way you want.

Regards
/Rauf Received on Mon Mar 07 2005 - 10:58:50 CET