Hi all,
I am new to stackoverflow, and this is my first question:
I would like to create a SSIS task on SQL 2005 server that queries a specific email account on an Exchange 2003 server, and creates a report.
The report currently contains the amount of emails received, average time of reply, and emails with reply time that have gone over a limit value.
For that, I am asking you guys if you know of any way to get email data from the exchange via SSIS out of the box? if not, whats the nicest/easiest way to query the Exchange 2003 Server for received email information (in VB.NET/ C#)? does the Exchange keep information regarding replies on a certain message?
Do you know of any free/ commercial solutions?
Thank you so much!