SSIS Exchange \ Outlook

StrangerDanger
StrangerDanger used Ask the Experts™
on
Using SSIS I need to connect into exchange folders for a number of network users to copy their emails and all attachments.  I need to download emails (with attachments) from an exchange server as *.msg files to a local folder using SSIS.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Sr. BI  Developer
Commented:
Hi,
What have you done so far? or which step you're stuck at?

it's really based on your exchange server version, you could configure a web service and let SSIS connect to it.
I used the ADO before, but there's other technologies
http://msdn.microsoft.com/en-us/library/ms876253%28EXCHG.65%29.aspx

there's also a third part connection
http://www.cozyroc.com/ssis/exchange-connection

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial