Thursday, March 19, 2009 7:49 PMHello,
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.
Friday, March 20, 2009 7:31 AMModeratorYuri,
Here is a link on OLE DB Provider for Exchange .
Though non-specific to 2007, hope it is helpful.
Kalman Toth, SQL Server 2008 Training, SSAS, SSIS, SSRS, BI: www.SQLUSA.com
- Marked As Answer by Kalman TothMicrosoft Community Contributor, Moderator Sunday, February 12, 2012 9:27 PM