Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Using SSIS : How to configure POP3 / Exchange server To receive emails into DB Expand / Collapse
Author
Message
Posted Saturday, September 5, 2009 8:10 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, September 19, 2013 2:22 PM
Points: 36, Visits: 283
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
Posted Monday, September 7, 2009 7:03 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, May 15, 2014 5:11 PM
Points: 6,067, Visits: 5,283
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
Posted Monday, September 7, 2009 7:22 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, June 5, 2014 10:54 AM
Points: 9,902, Visits: 9,480
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
Posted Monday, September 7, 2009 7:29 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 5:47 AM
Points: 1,904, Visits: 2,827
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
Posted Tuesday, June 8, 2010 6:51 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 5:27 PM
Points: 1,117, Visits: 2,219
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 »

Add to briefcase

Permissions Expand / Collapse