September 5, 2009 at 8:10 am
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
September 7, 2009 at 7:03 am
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
September 7, 2009 at 7:22 am
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]
September 7, 2009 at 7:29 am
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
June 8, 2010 at 6:51 am
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.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply