Import e-mailed attachment into SQL Server

  • 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

  • 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

  • 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/

  • 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

  • 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/

  • 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

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

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