如何在SSIS中将变量用作字符串的一部分 [英] How to use a variable as part of a string in SSIS

问题描述

我是SSIS的新手.

Hi,

I''m a newbie to SSIS.

我想发送一封带有发送邮件"任务的电子邮件，该邮件内容为

I want to send an email message with a Send Mail task that says,

The file C:\MyFile.txt was not found.

The file C:\MyFile.txt was not found.

但是C:\MyFile.txt 来自变量；即我可以打开MessageSource属性的Expression Builder并执行

but where C:\MyFile.txt is from a variable; i.e., can I open up Expression Builder for the MessageSource property and do

The file @[User::myFilePath] was not found.?

推荐答案

请查看此链接，可能对您有帮助 http://www.mssqltips.com/tip.asp ?tip = 1443 [ ^ ]

please see this link it may be helpful to youhttp://www.mssqltips.com/tip.asp?tip=1443[^]

这篇关于如何在SSIS中将变量用作字符串的一部分的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！