SQL Server Performance Forum – Threads Archive

Reading exchange server public folders from sql se

Dear all, As per the request we need to read exchange server public folder and populate the info into sql server.Can some one help me on this.
Can we do it with Dts ?Any suggestions are most welcome
Thansks DBA
SHAMS

Look at Steve’s articlehttp://www.sqlservercentral.com/columnists/SBoriotti/2985.asp in this case. You can take more advantage by looking into Sharepoint (MOSS 2007) & Office 2007 by integrating with SQL 2005. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Thanks for the quick responce.The given link will help us to update the contacts ,address ,etc in exchange server.I NEED to read the mails that are coming in public folder and insert in to sql tables. Thanks
DBA
SHAMS

Then you might need a third party toolhttp://www.gfi.com/mailarchiver/marfeatures.htm in this case and GFI MailArchiver, uses a SQL Server database to store the message data — a nice way to make use of SQL Server as part of your Exchange Server archiving setup.
Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

The management is not looking for a product but need to script the above requirement.
Any help or some API referance Thanks DBA
SHAMS

Nothing I’m aware of so far, I have seen mostly third party tools in this case. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

]]>