Click here to Skip to main content
14,547,127 members
Rate this:
Please Sign up or sign in to vote.
I have built an SSIS package which reads CSV from certain folder. But now I need to download same csv from exchange server.Also Outlook is not installed on my machine. Will I be able to download CSV from exchange server and how ? Thanks!

What I have tried:

I have found out it can be done through WebDav. Also I am trying to find out the code with the help of WebDav can be automated to download the attachment daily on specific time.
Updated 6-Jul-17 2:26am
PIEBALDconsult 5-Jul-17 17:51pm
I'd like to know that too. So far I only know how to write an Outlook rule (in VBA) that downloads the attachments, but it can't be automated, it has to be run manually.

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

I'd suggest using either IMAP or POP3 to fetch the email. You'll then need to parse the message to extract the attachment.

Fortunately, the hard work has already been done for you!
GitHub - jstedfast/MailKit: A cross-platform .NET library for IMAP, POP3, and SMTP.[^]
GitHub - jstedfast/MimeKit: A .NET MIME creation and parser library with support for S/MIME, PGP, DKIM, TNEF and Unix mbox spools.[^]

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100