ETL and Data Integration tools - Modern ETL software for everyone

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 seperate 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.

Chris

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?
Chris