ETL and Data Integration tools - Modern ETL software for everyone

We have a vendor that sends CSV files as email attachments. These CSV files contain statuses that are imported into our application. I'm trying to automate the process end-to-end, but it currently depends on someone opening an email, saving the attachment to a server share, so the application can use the file.

Since I cannot convince the vendor to change their process, such as offering an FTP location or a Web Service, I'm stuck with trying to automate the existing process.

Does anyone know of a way to programmatically open an email from a POP3 account and extract an attachment? The preferred solution would reside on a Windows 2003 server, be written VB.NET and secure. The application can reside on the same server as the POP3 server, for example, we could setup the free POP3 server that comes with Windows Server and pull against the mail file stored on the file system.

Red

Try Advanced ETL Processor enterprise

It offers several ways of working with emails

You can even use POP3 account and the data source and load emails into the database

www.dbsoftlab.com/etl-tools/advanced-etl...-transformation.html

Peter