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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » Using SSIS : How to configure POP3 / Exchange...

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

Rate Topic

Display Mode

Topic Options

Author

Message

NIRANJANA1977

Posted Saturday, September 05, 2009 8:10 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, January 10, 2013 10:50 AM
Points: 36, Visits: 282

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

Post #783332

Elliott Whitlow

Posted Monday, September 07, 2009 7:03 AM

SSCertifiable

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 12:02 PM
Points: 5,854, Visits: 4,873

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

Post #783766

RBarryYoung

Posted Monday, September 07, 2009 7:22 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Saturday, May 04, 2013 11:13 AM
Points: 9,855, Visits: 9,374

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.

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc. "Performance is our middle name."

Post #783774

Henrico Bekker

Posted Monday, September 07, 2009 7:29 AM

SSCommitted

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 2:24 AM
Points: 1,871, Visits: 2,692

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.

----------------------------------------------
Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.

Post #783780

CozyRoc

Posted Tuesday, June 08, 2010 6:51 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 10:02 AM
Points: 1,106, Visits: 2,115

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/

Post #933962

« Prev Topic | Next Topic »

Permissions