使用部署在另一台服务器上的SSIS包从Exchange服务器下载附件 [英] Downloading attachment from exchange server using SSIS package deployed on another server

问题描述

我已经构建了一个SSIS包，它从某个文件夹中读取CSV。但现在我需要从Exchange服务器下载相同的csv。而且我的机器上没有安装Outlook。我能从Exchange服务器下载CSV吗？谢谢！



我尝试了什么：



我发现了它可以通过WebDav完成。另外，我试图在WebDav的帮助下找出代码，可以在特定时间每天自动下载附件。

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.

推荐答案

我建​​议使用任何一种IMAP或POP3来获取电子邮件。然后，您需要解析消息以提取附件。



幸运的是，已经为您完成了艰苦的工作！

MimeKit [ ^ ]

GitHub - jstedfast / MailKit：用于IMAP，POP3的跨平台.NET库和SMTP。 [ ^ ]

GitHub - jstedfast / MimeKit：一个.NET MIME创建和解析器库，支持S / MIME，PGP，DKIM，TNEF和Unix mbox spools 。 [ ^ ]

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!
MimeKit[^]
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.[^]

这篇关于使用部署在另一台服务器上的SSIS包从Exchange服务器下载附件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！