Skip to Content
0
Nov 04, 2015 at 10:54 AM

BODS - Multiple Flat Files - Selecting the Latest File

966 Views

Hi BODS Experts,

We have two requirements in our Project.

Please help us how to resolve this.

Question 1:

We have multiple flat files naming --> Data_<uniquenumber>.csv


Now I have to load data from only one flat file which is created/modified at the latest.


So Please help us how can we write Data Services script language for this scenario.



Question 2:


Once data from the file is loaded, the file will be moved to Archive folder.


After 30 days, the file would be deleted in Archival folder.


So Please help us how can we write Data Services script language for this scenario.


Thanks & Regards,

Muthuram.