如何在SSIS中捕获磨损的消息 [英] how to catch the worning message in ssis

问题描述

在我的程序包中，我希望将磨损信息显示在``进度''选项卡中并将其记录到文件中.任何人都可以建议这样做.对于错误记录，有诸如ERRORCODE，ERRORDESCRIPTION之类的系统变量. ssis.

问候，
Sourav

Hi,
In my package I want to get the worning message displayed in the progress tab and log it into a file.Can any one suggets how to do that.For error logging there are system variables like ERRORCODE,ERRORDESCRIPTION.Are there any variables for worning in ssis.

Regards,
Sourav

推荐答案

您可以创建在"OnWarning"事件发生时发生的事件处理程序，就像您可以在"OnError"事件发生时进行事件处理程序一样发生.如果有多个警告，它将多次运行.您可以在包级别或仅在所需的执行级别创建事件处理程序.如果打开该程序包的日志记录，则还可以在日志文件中包含"OnWarning"消息.

You can create an Event Handler that happens when the "OnWarning" event occurs, just like you can do an Event Handler that happens when the "OnError" event occurs. If there are multiple warnings, it will run multiple times. You can create the Event Handler at the package level or just at the level of execution you want. If you turn on logging for the package, you can include "OnWarning" messages to the log file as well.

这篇关于如何在SSIS中捕获磨损的消息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！