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.
| 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 OutlookGerald Britton, MCSAToronto PASS Chapter |
 |
|
|
|
|
|
Parse email to SQL table