记录SSIS数据流中的错误描述（VS2008 BIDS） [英] Recording error descriptions in an SSIS Data Flow (VS2008 BIDS)

问题描述

我正在尝试使用事件处理程序来记录我的SSIS包中的错误。不幸的是，没有选项可以在数据流任务中的各个任务中添加事件处理程序;因此，我在控件流程级别为整个数据流任务添加了一个事件处理程序。

I'm trying to use event handlers to log errors in my SSIS packages. Unfortunately there is no option to add event handlers to individual tasks within a data flow task; I have consequently added an event handler to the overall data flow task at the control flow level.

当数据流任务发生错误时，我希望这个事件处理程序触发一次，记录错误和任何类型的错误描述可能。

When an error occurs within the data flow task I would like this event handler to trigger once, recording the error and any kind of error description possible.

我最初将错误处理程序触发器设置为 OnError ，但是这会触发多次（当组件数据流任务失败时，整个包失败等）。我更改为一个 OnTaskFailed 触发器，但这似乎没有一个System :: ErrorDescription变量可用于记录。

I initially set the error handler trigger to OnError, however this triggers multiple times (when a constituent data flow task fails, when the overall package fails, etc.). I changed to an OnTaskFailed trigger, however this does not appear to have a System::ErrorDescription variable available for logging.

我错过了一些？是否无法从数据流任务故障提供单个错误消息？这是在以后的版本中修复的东西吗？

Am I missing something? Is there no way to provide a single error message from a data flow task failure? Is this something that is fixed in future versions?

此问题在VS2008 BIDS

推荐答案

BIDS 2008中的数据流任务不可能使用错误处理程序进行简明的错误记录。

Concise error logging using error handlers is not possible for data flow tasks in BIDS 2008.

唯一的选择是在数据流任务本身（通过SQL或脚本任务）中使用直接日志记录，或在控制流程级错误处理程序中记录多个错误消息。

The only options are to use direct logging within the data flow task itself (via SQL or script tasks), or record multiple error messages at the control flow level error handler.

这篇关于记录SSIS数据流中的错误描述（VS2008 BIDS）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！