Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SSIS Exchange \ Outlook

Posted on 2012-04-09
1
Medium Priority
?
2,023 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:
Jason Yousef, MS earned 1500 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

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

On September 18, Experts Exchange launched the first installment of the Help Bell, a new feature for Premium Members, Team Accounts, and Qualified Experts. The Help Bell will serve as an additional tool to help teams increase question visibility.
With so many activities to perform, Exchange administrators are always busy in organizations. If everything, including Exchange Servers, Outlook clients, and Office 365 accounts work without any issues, they can sit and relax. But unfortunately, it…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
This video demonstrates how to sync Microsoft Exchange Public Folders with smartphones using CodeTwo Exchange Sync and Exchange ActiveSync. To learn more about CodeTwo Exchange Sync and download the free trial, go to: http://www.codetwo.com/excha…
Suggested Courses

971 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