Help with Active X Script in DTS Package

[S1002]

Please help me

I have a DTS package with ActiveXScript that can process
any number of files(CSV files) but the logic in the SQLcode
inside the package needs the files to be processd in an order by the name of the file,example say i have 3 files--

(left 8 digits in the file name is the actual date of the file)

1.20070825test.CSV(
2.20070824test.CSV
3.20070826test.CSV

the actual order to process the files should be
1. 20070824test.CSV
2. 20070825test.CSV
3. 20070826test.CSV


my package is processing inthe reverse way.

 

[AlexCuse]

Bring your file names into a recordset, ordering by file name as you do so. This will make sure that 8/24 is in position 0 of your recordset, and should be the first file processed.

If you need more help go to this forum forum961

and please provide more information on how you are processing these files.

Hope it helps,

ALex

[small]----signature below----[/small]
I don't do any programming whatsoever

Ignorance of certain subjects is a great part of wisdom

 

[S1002]

i will try this
Thank you so much Alex