SSIS 的错误日志 [英] Error Log for SSIS
问题描述
我正在通过 SSIS 导入一些数据,以防某些记录没有被推送,我将这些错误写入 .txt 文件:
I am importing some data through SSIS , in case some records don't get pushed , I am writing those errors in a .txt file :
例如
abcColumn 的数据推送失败:8702170000,数据值违反完整性约束.
Data Push failed for abcColumn: 8702170000,The data value violates integrity constraints.
但是当列 'abcColumn' 为空时
But when the column 'abcColumn' is blank
它只是显示
,数据值违反完整性约束.
,The data value violates integrity constraints.
我不能将其显示为:
为 abcColumn 推送的数据:空白/空/_(空格),数据值违反完整性约束.
Data pushed for abcColumn : blank/null/_(space) ,The data value violates integrity constraints.
推荐答案
看来您需要在您的包中实现自定义错误处理机制,以便您可以获得您选择的错误消息.
It seems you need to implement custom error handling mechanism in your packages so that you can get error message of your choice.
以下是一些可以作为起点的资源.
Below are the few resources which can be served as starting point.
这篇关于SSIS 的错误日志的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!