how to import emails

[new DBA in '09]

Hi All,

I'm being tasked with importing emails regarding service interruptions
from several different ISP's into SQL Server 2008 R2. I've never done
this before. Where should I start?

Thanks,
Eric

[John Bell]

Hi

You don't say how you are going to get access the email? You can use
SQLMail to access a mailbox, but in SQL 2008 SQLMail is only present
for backward compatibility and could be dropped in a future version.
SQLMail requires a MAPI client which usually means installing Outlook
on the server which has security implications.

John

[Mary Chipman [MSFT]]

The simplest way to do this might be to use a client tool such as
Access, which can link directly to SQL Server tables. Since you're
presumably behind a firewall, this shouldn't present any security
issues. You don't say what format(s) the emails are coming to you in,
or how you want them treated in SQL Server, which will make a
difference. If all you want is the text/data, then it should be fairly
straightforward.

--Mary

On Wed, 1 Sep 2010 13:08:11 -0700 (PDT), "new DBA in '09"
<ericb...@gmail.com> wrote:

[new DBA in '09]

Thanks to both of you. You've forced me to think about factors that I
didn't know existed.

Much appreciated.