Using SSIS : How to configure POP3 / Exchange server To receive emails into DB

  • Dear All

    I want to configure clients pop3 email account and exchange server accounts such a way that each and every mail should be inserted into database table. Is there any way of doing this in SSIS. Is there Any component available for this stuff.

    Thanks in advance

  • There's a whole lot of questions here..

    1. Is SQL Sending these emails?

    2. Do you expect SQL to go out to the POP3/Exchange and get the emails?

    3. What is the purpose of archiving the emails?

    Those are just the ones off the top of my head..

    CEWII

  • I don't know of any Freeware that does this (I actively looked for it about a year ago). A colleague of mine tried to write his own after that and realized that it was a far from trivial task.

    There are some for-sale products that claim to do it, but I cannot vouch for them.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]

  • I dont think (my own personal opinion) that SQL was designed for this type of input data?

    rather stick to the basics and backup the mails or even enable and configure Auto-Archiving.

    Else, write code that actually dumps your mail contents in txt files (i know this defeates the whole goal)

    and have ssis import the flat files on an hourly basis.

    just a suggestion.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • If you can use third-party solutions, check the commercial CozyRoc Receive Mail Task. It supports both POP3 and IMAP for connecting to mail server.

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

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

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