SSIS 无视 Execute Package task 控件的错误, 不会导致整个package报错的方法

http://stackoverflow.com/questions/697538/ignore-errors-on-execute-package-task-in-ssis

"A better way to do this is to go to the OnError handler of your execute package task and set the System variable "Propogate" to false. This will stop the error from bubbling upwards to your loop container."

在Event Handlers中找到对应的控件(Executable), 右边选择OnError, 打开Variables窗口, 找到"Propogate", 并将其设置为 false.

补充：

当mdx返回结果有 -1.#IND 时, SSIS会报错

这时要到源控件的 advance editor中配置为"Rd_IgnoreFailure"