无法在Azure VM上从SSIS发送电子邮件附件 [英] Unable to send email attachment from SSIS on an Azure VM

问题描述

它能够创建文件，因此可以正确设置引用的路径.但是，当它尝试引用文件(作为电子邮件附件)时，错误地指出无法在变量集合中找到user :: FilePath.如果我不这样做，它会很好地运行 有电子邮件附件.我知道电子邮件附件参考设置正确，因为它可以通过Visual Studio从本地计算机成功运行，但前提是我将其指向我的c:驱动器.如果我引用网络驱动器，即使运行，它也会失败 在我的本地计算机上.

It is able to create the file so the referenced path is set up correctly. However, when it tries to reference the file (as an email attachment), it errors saying it cannot find the user::FilePath in the variables collection.  It runs fine if I do not have an email attachment.  I know the email attachment reference is set up correctly because it runs successfully from my local machine via Visual Studio but only if I point it to my c: drive.  If I reference a network drive it fails, even when running from my local machine.

FilePath = X:\ Imports \ Test \ Daily \

FilePath = X:\Imports\Test\Daily\

完整路径和文件名如下

EmailFileName = X:\ Imports \ Test \ Daily \ abc.csv

EmailFileName = X:\Imports\Test\Daily\abc.csv

推荐答案

Hello,

https://ashiknesin.com/blog/send-email-attachments-sendgrid/

Please allow me to suggest using SendGrid components.

https://ashiknesin.com/blog/send-email-attachments-sendgrid/

me = CDATASOFTWARE.SendGridSSISComponents

https://marketplace.visualstudio.com/items?itemName=CDATASOFTWARE.SendGridSSISComponents

https://docs.microsoft.com/en-us/azure/sendgrid-dotnet-how-to-send-email

Hope this helps.

Regards,

SQLCoffee.com

Alberto Morillo
SQLCoffee.com

这篇关于无法在Azure VM上从SSIS发送电子邮件附件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！