SSIS 失败包失败 [英] SSIS fail package on failure

问题描述

我是 SSIS 的新手.我正在尝试将数据从 excel 加载到 sql server.excel 中的每个工作表都应该放入 sql server 中的单独表中，因此我创建了一个序列容器，并在其中放置了数据流任务.每个数据流任务都包含将数据从一个 Excel 工作表移动到 sql server 中的表的逻辑.所以问题是，如果一个数据流任务失败，那么我预计整个包都会失败并回滚其他数据流任务所做的更改.但它没有这样做.其他数据流任务正在提交到 sql server.

I'm new to SSIS. I m trying to load data from excel to sql server. Each sheet in excel should go into separate table in sql server so I created a sequence container and inside that I have placed data flow tasks. Each data flow task contains logic to move data from one excel sheet to table in sql server. So problem is if one data flow task fails then I was expecting whole package will fail and rollback the changes done by other data flow tasks. But its not doing that. Other data flow tasks are getting committed into sql server.

对于序列容器和单个数据流任务，我已将属性Failpackageonfailure"设置为 true.还将事务设置为必需"，但结果没有变化.

I have set the property "Failpackageonfailure" to true for sequence container and individual data flow tasks. Also set the transaction as "Required" but no change in results.

请帮忙！

提前致谢

西

推荐答案

您还可以将 Required 设置为一个新创建的序列容器，其中包含控制流项(以防您的包执行其他不符合一样).

You could have also set Required to a newly created sequence container with the control flow items inside of it (in case your package does other tasks that do not behave the same way).

这篇关于SSIS 失败包失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！