ETL and Data Integration tools - Modern ETL software for everyone

I rec reeive a file each day as an e-mail attachment. The attachment is not consitantly named, although it always ends with .txt. I am currently using a mask to select the file for transformation (using *.txt as mask when looking for file).

After I complete the transformation and write the file to the db, I would like to rename the file from *.txt to DATE.done

How do I do this?

Thanks

Frank

Brilliant question

Well it is not strait forward but it is possible

Use file operation action
set operation type to merge file
set source files to whatever the path is + mask
set target file to path\Data{GetSystemDate('YYYYMMDD')}.txt

As long as you got only one file matching mask in the directory it should work

Peter