Post reply

How to read Microsoft Excahnge server to check mails recieved using SSIS

  • October 24, 2009 at 12:32 am

    #136883

    I have a req to read mails from Microsoft exchange server and take action if there are mails received.Please help me by providing a snippet of code

  • October 25, 2009 at 7:40 am

    #1070435

    latheesh.jaya (10/24/2009)

    I have a req to read mails from Microsoft exchange server and take action if there are mails received.Please help me by providing a snippet of code

    You can use POP3 protocol to get emails from Exchange server. However there is no readily available code you can use because the process is not straight. If you can use third-party components, check Download Mail task.

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

  • November 25, 2009 at 6:05 pm

    #1084408

    CozyRoc (10/25/2009)

    latheesh.jaya (10/24/2009)

    I have a req to read mails from Microsoft exchange server and take action if there are mails received.Please help me by providing a snippet of code

    You can use POP3 protocol to get emails from Exchange server. However there is no readily available code you can use because the process is not straight. If you can use third-party components, check Download Mail task.

    I have similar requirement and I have done heavy research. You would need to get a third party library for either pop3 or I think SMTP and even then it is very, very difficult. We have opted against connecting to exchange.

    Josef Richberg
    2009 Exceptional DBA
    http://www.josef-richberg.squarespace.com
    http://twitter.com/sqlrunner

  • June 8, 2010 at 6:50 am

    #1177435

    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 4 posts - 1 through 3 (of 3 total)

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