ETL and Data Integration tools - Modern ETL software for everyone

Could I schedule to import a file that I don't know ahead of time? Another word, I like to import all file in the directory when the schedule run.

You can specify a mask for impot file.
If I undertood correctly what you want

basically my file format will be filenameyyyymmddhhmi.txt, the yyyymmddhhmi is dynamic which represent the year, month, date, hour, & minute. So what you are saying is we can mask the file as:
filename????????????.txt?

Hi Again

You can use
filename????????????.txt mask
or filename*.txt
or you van use example provided on the front page.

It is all depends how often you generate your files and how often you want to load them.

If is is not good enough or not exactly what you want we are always happy to listen to your suggetions and if necessary add those new fetures to the next release free of charge.

Mike

filename*.txt seems to be what I need, is that mean it will pickup all the files that start with filename*.txt? If it is, then it's perfect for my usage.
"you van use example provided on the front page." <--which one are your referring to?

Processing yesterday’s data using Visual Importer Pro 7.3.7

Consider the following scenarios.

• Every day we export data from our database and would like to save it into different file using current date as a part of the file.
• We would like to load yesterday’s data from the folder which has date part in the name

The Rest is on the front page