Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 Parse email to SQL table

Author  Topic 

reidkell
Starting Member

16 Posts

Posted - 2015-05-04 : 20:15:49
Hello, all. I have been tasked with parsing incoming (Outlook 2010 via Exchange) emails and storing the key info (sender, subject, date, body, etc) into SQL Server. I'm currently using SQL 2008 R2 but am standing up a new 2014 server very soon.

Having never done this before, am hoping for some direction/advice on how to proceed. I can't purchase any additional software and probably need to rely on a local instance of Outlook. Fortunately, the mailbox is dedicated to this effort, so most email will be simple and structured. I'm guessing I'll need to export the email to TXT files, then can use SSIS to do the rest, but not sure.

Any info appreciated.

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-05-04 : 21:34:45
You could SSIS script component to read directly from Outlook

Gerald Britton, MCSA
Toronto PASS Chapter
Go to Top of Page
   

- Advertisement -