Hi,
We are having daily loaded files in a server and we need to load those daily increment files to DB.
The file format is
*****20110227.txt
*****20110228.txt
*****20110228.txt
These files are located at another server and we do have rights to copy files. The package executes fine for the first time. But the other day we will be having newly added files and we need to control the package to consider only the most recent files i.e...
*****20110227.txt
*****20110228.txt
*****20110228.txt
*****20110301.txt
*****20110302.txt
*****20110303.txt
We need to ignore the files which were already loaded and need to consider the most recent files in sequential order.
Can you please suggest a best approach for handling this.
Thanks,
Naru