ETL and Data Integration tools - Modern ETL software for everyone

Hello

I have 3 e-mails message coming daily to a single account, each with it\'s own attachment that I need to parse into MS SQL server 2008.

Can the e-mail client be setup to recognise the message header, and then parse the attachment into the appropriate table?

Or,
Do I need to setup 3 separate e-mail address accounts to pop and then parse accordingly.
What is the best way to handle this. I assume that your package can be setup to work with multiple e-mail accounts.

Beat

Hello

There is no need to use header in your case as log you are receiving
different files.

For example you have 2 retail shops
first retail shop will email file "retail shop 1 sales.xls"

second retail shop will email file "retail shop 2 sales.xls"
so your package would be as follows

Clear directory you are saving attachments into
Receive email and save attachment into directory
Check if "retail shop 1 sales.xls" exists

load data into the database

Check if "retail shop 2 sales.xls" exists
load data into the database

Hope that helps
Mike

Thanks, but, the problem is that the attachments all have the same name (and this is something that we can't control). The only way to differentiate the attachment (or which attachment should be parsed into which table) is by using the header of the e-mail.

What is the best way to approach this?

B

also, we can send the e-mails to their own pop accounts. The only control we have is the header name. All files are called landscapeopera.txt, but, each represents a different file to go into a different table.

Examples of the email headers are

OR_trans_export

OR_Guest_details_inhouse
OR_With_Room_BLock

B

ok since you can send the e-mails to their own pop accounts I suggest to have a look at Advanced ETL Processor Pro/Ent which supports multiple email accounts

(Visual Importer Pro can use only one email account)

Mike