Solved

SSIS Exchange \ Outlook

Posted on 2012-04-09
1
1,748 Views
Last Modified: 2012-04-18
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.
0
Comment
Question by:StrangerDanger
1 Comment
 
LVL 21

Accepted Solution

by:
huslayer earned 500 total points
ID: 37827536
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
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Join & Write a Comment

Utilizing an array to gracefully append to a list of EmailAddresses
This process describes the steps required to Import and Export data from and to .pst files using Exchange 2010. We can use these steps to export data from a user to a .pst file, import data back to the same or a different user, or even import data t…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now