You are not logged in.
Yes, as Michael said, you can use tFileList and use the file path, set the file mask as: ORALD01.*, and then do some validate, filter as needed.
you can use the tfileList and use the variable FilePath, i think.
Or maybe if your extension is based on some kind of date information use a function.
I'm using TMSSqlBulkExec to populate a table from a flat file.
The problem is that this flat file extension changes every month (ex: ORALD01.M01 next month is ORALD01.M05), is there a way to say in the Remote Filename field that the filename always begins with ORALD01? Something like "D:\Temp\ORALD01*"?
Thanks in advance for your help