ETL and Data Integration tools - Modern ETL software for everyone

Hello

I am currently receiving e-mails that have attachments.
Even though the attachments are the same format text file, they always have a different name.

For example, over the course of a 5 day period, the attachments may be called:

portrait010101.txt
portrait043532.txt
portrait984324.txt
portrait234523.txt

I have the mask defined to always look for .txt

In the screenshot that I sent you though, the reader always seems to look for the same file name and not using the extension part of the mask. I have the mask setup to look for *.txt (where * is the wildcard part of the mask). Does this support * as a wildcard?

See the error message below that pops up.

The file reservations070109.txt is an old file. It was processed previously, and it has been removed. The new file will have a new name, but the extension will remain as .txt

Wolf

I see what you mean now

No this part does not use masks.
It just points to the last file used by the user which can be anywhere.

The problem you got that the file is deleted every time you run the package,
why do not you copy a file into the different directory where it will not be deleted and use this file instead?

Peter

I am not sure I understand how to resolve this problem.

The bottom line is that I am going to receive a different attachment name every day. How do I process these?

W

You have already done everything to make it work
Add your transformation to the package and and run it you will see what I mean

Mike