如何使用程序包配置在SSIS中动态配置发送邮件任务 [英] How to configure send mail task dynamically in SSIS using Package Configuration

问题描述

大家好，

我有一个发送邮件任务，它将excel作为附件发送。我们在CC，BCC和to中都有几个ID。我想使用包配置动态配置发送邮件任务，因此它动态地获取所有ID，邮件主题和messageSourse。如何在SSIS中实现这一点？



我必须通过包配置来配置smtp连接。

如何在SSIS中实现这一目标？



提前致谢

Hi All,
I have a send mail task which sends the excel as attachment. We have couple of ids in CC, BCC and to. I want to configue send mail task dynamically using package configuration, So it takes all ids, message subject, and messageSourse dynamically. How to achieve this in SSIS?

I have to configure that smtp connection also through package configuration.
How to achieve this in SSIS?

Thanks in advance

推荐答案

嗨那里，



我对SSIS没什么了解，但我建议的解决方案是创建一个简单的调度服务（Windows服务）并触发在任何特定时间间隔后通过此服务打包。



您可以将CC，BCC，主题行和邮件正文作为SSIS包中配置的变量，可以根据需要填充来自c＃代码。



基本上在包级别添加用户变量，然后在发送邮件任务中使用消息源的表达式编辑器。



如果您需要任何帮助，请告诉我。



问候

Hi There,

I don't have much idea on SSIS, but the solution which i suggest is to create a simple scheduler service (windows service) and trigger the package through this service after whatever specific time intervals.

You can have CC,BCC,Subject Line and Mail Body as variables configured in SSIS package which can be populated as required from c# code.

Basically add user variables at the package level and then use the expression editor of the message source in the send mail task.

Let me know if you need any help on this.

Regards

这篇关于如何使用程序包配置在SSIS中动态配置发送邮件任务的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！