gpt4 book ai didi

ssis - SSIS-即使在Foreach循环容器中的内部任务失败后,仍继续包流

转载 作者:行者123 更新时间:2023-12-04 13:41:34 24 4
gpt4 key购买 nike

在下图中,尽管正确处理了(失败的DFT的)失败路径,为什么Foreach循环容器仍然失败?

处理失败路径后如何使循环继续?

如果它有助于了解包装中的情况,请按照以下要点进行操作:

We have a requirement where data from Excel files must be loaded into a DB. The package we have splits each Excel file into constituent CSV files (one CSV per sheet), and loads the CSVs into the DB. It is possible that some of the sheets have issues (missing columns, data type mismatch etc), and such erroneous CSVs are captured by the fail path of the DFT. Ideally the package must resume processing the rest of the CSVs, and the rest of the Excel files, and exit successfully.

最佳答案

您是否为该数据流任务定义了 OnError EventHandlers?如果是,您还可以将错误处理程序作用域的系统变量 Propogate ( bool 类型)设置为'False'

还请通过Gracefully Handing Task Error in SSIS Package

关于ssis - SSIS-即使在Foreach循环容器中的内部任务失败后,仍继续包流,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/13414648/

24 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com