I am in the midst of the project that has the following requirements:
- Enable my SQL 2008 server to periodically connect to Exchange 2007 server; - Retrieve any mail sitting in the INBOX of a specifis account; - Parse email messages into separate fields (date, subject, body of the message, attachments); - Store the data parsed in a table of the SQL server.
Does anyone know if it is possible to have Exchange 2007 server made a linked server to SQL server? If yes, how to do this (SQL server does not have the Echange data provider). Is it also theoratically possible to use SQL to query against Exchange INBOX?
If this approach is not possible... any other ideas how to arrive at the result described above?
Thank you all in advance.
PS.. I was told of the OLE DB Provider for Echange, however (as i understand it), the OLE DB Provider for Echange will only work when SQL and Exchange Web Store are located on the same computer. In my case, they are on two separate boxes, and Exchange 2007 server is not under my control.
Moved byJamie MacLennanFriday, March 20, 2009 12:04 AMWrong forum (Moved from Data Mining to Transact-SQL)