ssis - MessageSource 表达式 - 无法锁定变量

Question

我正在尝试使用发送邮件任务在成功完成数据流任务后发送消息。

执行包时，产生错误:

Error: Failed to lock variable "The extraction was successful.

PROPERTIES

Starting: 10/27/2015 Ending: 10/27/2015 11:59:59 PM Records: 207 " for read access with error 0xC0010001 "The variable cannot be found. This occurs when an attempt is made to retrieve a variable from the Variables collection on a container during execution of the package, and the variable is not there. The variable name may have changed or the variable is not being created.".

发送邮件任务的 MessageSourceType 设置为 Variable。

分配给发送邮件任务的 MessageSource 属性的表达式:

"The extraction was successful.\n\n" +
"PROPERTIES\n" +
"----------\n\n" +
"Starting: " + (DT_WSTR, 50) @[$Project::StartingDateTime] + "\n" + 
"Ending: " + (DT_WSTR, 50)  @[$Project::EndingDatetime] + "\n" + 
"Records: " + (DT_WSTR, 50) @[User::OriginalRecords] + "\n"

User::OriginalRecords 变量正在(正确地)由行计数任务填充。

我做错了什么？

Answer 1

我需要将发送邮件任务的 MessageSourceType 设置为 Direct Input。 Credit .