ETL and Data Integration tools - Modern ETL software for everyone

Hi

I have the following situation:
I get several text files with the same layout in a specific directory.
I have to merge these various files into one to make the load. So far so good.
But what I'm doing is letting the ETL process dynamics
Example: The ETL process verifies the first text file directory and performs the load.
The ETL process verifies the second text file directory and performs the load.
The ETL process verifies the third text file directory and performs the load, and so on.

Carl

I am very confused about your post.
And do not understand what the problem is.

Why do not you just use mask for source files?
Mike

Mike,

Can you send me an example?

Carl

Here is the link

www.dbsoftlab.com/Advanced-ETL-Processor...o-MS-Sql-Server.html

Mike