all groups > sql server dts > september 2004 >
You're in the

sql server dts

group:

MS Exchange to SQL Server


MS Exchange to SQL Server pErI
9/7/2004 1:57:02 AM
sql server dts:
I don't know if this is possible: Is there a way where in MS Exchanges data
and info are replicated or somewhat transmitted to sql server. I know i have
heared it somehow using dts......somebody can answer, I just need something
that will give me a "go signal", so that I can research. I don't want to
Re: MS Exchange to SQL Server Darren Green
9/7/2004 10:11:17 AM
This is not something I have done, but I believe Exchange ships with a
Microsoft OLE DB Provider for
Exchange.

From Books Online-

OLE DB Provider for Exchange

The Microsoft® OLE DB Provider for Exchange exposes data stored in a
Microsoft Exchange 2000 Web Store in tabular form. This data can be
queried using an SQL-like language that is very similar to the SQL
subset supported by the OLE DB Provider for Microsoft Indexing Service.

Microsoft SQL ServerT 2000 distributed queries can be used to query data
from the Exchange Web Store through this OLE DB Provider and can be
joined with tables in SQL Server. The Exchange Web Store should be
located in the same computer as SQL Server. Web Stores located in other
computers cannot be accessed using the OLE DB Provider for Exchange.


Saying that I believe you need Exchange and SQL on the same machine for it
to work. Another option would be to use ADSI to get the data out.


--
Darren Green
http://www.sqldts.com

[quoted text, click to view]

AddThis Social Bookmark Button