dbTalk Databases Forums  

MS Exchange to SQL Server

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss MS Exchange to SQL Server in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
pErI
 
Posts: n/a

Default MS Exchange to SQL Server - 09-07-2004 , 03:57 AM







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
search for nothing....thanks......and god bless

Reply With Quote
  #2  
Old   
Darren Green
 
Posts: n/a

Default Re: MS Exchange to SQL Server - 09-07-2004 , 04:11 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

"pErI" <pErI (AT) discussions (DOT) microsoft.com> wrote

Quote:
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
search for nothing....thanks......and god bless



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.