Hi Experts, I have to create statistics about the traffic in an Exchange mailbox (about e-mails arriving from customers). With SSIS, I would like to achieve something similar what happens, when you import or link your Outlook inbox to an Access database. I have been searching over the internet for solutions, without success. As there is no built-in "outlook data source", I checked what I can do with web services, but the WSDL file provided by OWA does not work with web service task, the dropdown lists to select the service / method are empty. I would like first to ask the best approach, and then some guide to this solution. So far I created only data transfer packages from Excel and SQL, I am not really familiar with the scripting part. Thanks, vm

Yes, there is no Exchange data source because SSIS was not provisioned to access MS Exchange, frankly why would you use SSIS for that? AFAIK Crystal Reports can generate such a report so no need for ETL there. However, you can use ADO to access the Exchange server, here are code examples: http://msdn.microsoft.com/en-us/library/aa123760%28EXCHG.65%29.aspx And yes, you will need a script task, in which you may may want to dump each record into somewhere, but this is not elegant and like I said not SSIS centric and can be done using an executable written in say VB, C#, etc.Arthur My Blog

Arthur, I am thinking in SSIS, because we are already using this for other tasks. Also, ExOLEDB only works on the exchange server, and we need a solution that works from our SQL server. ( http://msdn.microsoft.com/en-us/library/Aa142634 ) Crystal reports is not a solution, as the VS 2008 coming with SQL Server 2008 does not contain Crystal. Thanks, vm

Ok, maybe I did something very stupid, but if I select an OLE BD source and put the following text into the db file name: Provider=Microsoft.JET.OLEDB.4.0;Exchange 4.0;MAPILEVEL=Outlook Address Book\;PROFILE=Outlook;TABLETYPE=1;DATABASE=c:\users\myself\; Then click "test connection", I am prompted for my profile, and the test result is ok. However the connection string is wrong, because it should be an x=y type string. So, what shall I put before "Exchange 4.0" to meet the syntac requriements? Thanks, vm