I have multiple FTP sites that will have random files created daily, I need to import only certain file names with the current date timestamp.

Is there a custom ActiveX script or Batch file or FTP command that will check time stamp, and file name ie *list*.csv currentdate

my other option is to use a lookup table that contains each file name and a date field that is updated by the export process on the other end, utilizing this table, have DTS lookup fields with the current date, and append those file and server names to the import process to only import current files.

Any suggestions or examples are more than welcome
Thanks ahead
M