Import e-mailed attachment into SQL Server

Question

Import e-mailed attachment into SQL Server

Tim Mitchell

SSCoach

Points: 15681
More actions
June 28, 2010 at 7:00 am

#387228

Has anyone had any experience setting up an SSIS package (or other ETL mechanism) to automagically import a data file received as an e-mail attachment? I've got a vendor I'm dealing with that currently delivers scheduled CSV files only as e-mail attachments. If anyone has done this before, I'd like to hear what approach you took and how well it worked.
Thanks,
Tim
Tim Mitchell, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 1

First off, I have not actually done this. But I would think you would need a tool to read the inbox, and then take the message and strip the attachement out and then ETL it was normal.

CEWII

COZYROC One Orange Chip Points: 28499 More actions · Answer 2

Tim Mitchell (6/28/2010)
Has anyone had any experience setting up an SSIS package (or other ETL mechanism) to automagically import a data file received as an e-mail attachment? I've got a vendor I'm dealing with that currently delivers scheduled CSV files only as e-mail attachments. If anyone has done this before, I'd like to hear what approach you took and how well it worked.
Thanks,
Tim

Hi Tim,

If you can use third-party solutions, check the commercial CozyRoc Receive Mail Task. You can open MIME-encoded mail file or download directly from POP3 or IMAP email server. The task also supports decryption of S/MIME emails (in case you need that).

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 3

You know Cozy, I recommend people look at your components quite a bit, I might need to download them and spend some time looking at them in greater detail myself..

CEWII

COZYROC One Orange Chip Points: 28499 More actions · Answer 4

Elliott Whitlow (6/29/2010)
You know Cozy, I recommend people look at your components quite a bit, I might need to download them and spend some time looking at them in greater detail myself..
CEWII

Thank you for the recommendations, Elliott! Do not hesitate to contact, in case you have questions.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Tim Mitchell SSCoach Points: 15681 More actions · Answer 5

If you can use third-party solutions, check the commercial CozyRoc Receive Mail Task. You can open MIME-encoded mail file or download directly from POP3 or IMAP email server. The task also supports decryption of S/MIME emails (in case you need that).

Good info, thanks. A third party solution *might* be an option in this case... I'll ping you offline to find out how to get a copy of this component.

Thx,

Tim

Tim Mitchell, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices