database SSIS - 源错误输出（不会将行发送到错误输出......）
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/6541167/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
SSIS - Source Error Output (No rows will be sent to error output(s)....)
提问by piris
I'm a newbie in SSIS... I'm exporting data from a DBSource and outputing any errors to a Flat File. Now, when I connect the red arrow to the Flat Destination I'm receiving a warning from the DB Source "No rows will be sent to error output(s). Configure error or truncation dispositions to redirect rows to the error output(s), or delete data flow transformations or destinations that are attached to the error output(s)."
我是 SSIS 的新手...我正在从 DBSource 导出数据并将任何错误输出到平面文件。现在，当我将红色箭头连接到平面目标时，我收到来自数据库源的警告“不会将行发送到错误输出。配置错误或截断处置以将行重定向到错误输出” ，或删除附加到错误输出的数据流转换或目标。”
Does anyone know what it means? How can I get rid of that?
有谁知道这是什么意思？我怎样才能摆脱它？
回答by Daryl Wenman-Bateson
By default, SSIS will "Fail component" on an error or truncation issue. You must tell SSIS that you do not want to fail the package, but you want to "Redirect Row" which will allow the flow to continue down the red arrow.
默认情况下，SSIS 将在错误或截断问题上“使组件失败”。您必须告诉 SSIS 您不想使包失败，但您想要“重定向行”，这将允许流继续沿红色箭头向下。
- Edit your Source
- Go to the Error Output tab
- Set the relevant columns you want to trigger an error row redirect to Redirect Output as below.
- 编辑您的来源
- 转到错误输出选项卡
- 将要触发错误行重定向的相关列设置为重定向输出，如下所示。
This should remove the warning message you are currently getting
这应该删除您当前收到的警告消息
