SSIS 包是否失败，当其中一个容器失败时 [英] Does the SSIS Package fail ,when one of the container failed

问题描述

我有一个包含 1 个容器的包.如果该容器失败，ssis pacakge 是否会失败！?属性

<块引用>

失败时的失败包对于容器来说是假的.

这是否意味着仅当此属性设置为 TRUE 时包才会失败，否则只有容器状态为失败，而包状态不是！?

解决方案

是的.如果 Sequence Container 失败，整个包都会失败.提高序列容器的 MaximiumAllowedErrors 属性以获得您想要的行为.

示例

下面我们有一个示例包.序列容器有一个永远不会成功的任务.

如上，Sequence Container 失败，Package 失败.下面是上面容器的属性.这些是新容器的默认值.

现在让我们停下来学习.如果我们将包行为与属性设置进行比较，这看起来是错误的.这里我们设置了 FailPackageOnFailure=False，但是 Sequence Container 故障导致了 Package 故障.为什么是这样?不直观的属性名称.请参阅

这将允许您拥有一个失败的序列容器，但不会使整个包失败.

希望这会有所帮助！

I have a package with 1 container.Does the ssis pacakge fail,If that container fail!? The property

FAIL PACKAGE ON FAILURE is false for the container.

Does that mean the package fail only if this property set to TRUE,other wise only the container status is failed ,and the package status is not !?

解决方案

Yes. If the Sequence Container fails, the overall package will fail. Raise the MaximiumAllowedErrors property of the Sequence Container to get the behavior you want.

Example

Below we have an example package. The Sequence Container has a task that will never succeed.

Above, the Sequence Container has failed and the Package has failed. Below are the properties of the container above. These are the default values for a new container.

Now lets stop and study. If we compare the package behavior against the property settings, this looks wrong. Here we have set FailPackageOnFailure=False, yet a Sequence Container failure is causing a Package failure. Why is this? Unintuitive attribute names. See this Microsoft Connect issue. You are not alone in your confusion. The official explanation from Microsoft is this.

Despite some pretty circular previous messages, we believe that the feature is behaving as designed. When you set FailParentOnFailure to false, the parent will not fail until the number of failures in the child exceeds the MaximumAllowedErrors threshold. When you set FailparentOnFailure to true, the parent will fail on the first occurence of an error regardless of the MaximiumAllowedErrors threshold.

The important piece of information to take away from that quote is that the FailPackageOnFailure and MaximiumAllowedErrors work as a pair!!!

So - knowing this - we can achieve the expected behavior by raising the MaximiumAllowedErrors count from 1 to 2.

This will allow you to have a sequence container which fails, but does NOT fail the overall package.

Hope this helps!

这篇关于SSIS 包是否失败，当其中一个容器失败时的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！