使用 SQL 查询禁用 SSIS 中的序列容器? [英] Disable a sequence container in SSIS using SQL query?

问题描述

假设我有一个 SSIS 包，它有近 20 个序列容器，并且在运行作业时，一些序列容器成功完成但有一些失败.所以，在这里我想要一个自动化的 SQL 查询来禁用已完成的序列容器并启用失败的序列容器，这样如果我再次运行该包，它将只运行失败的序列容器.

是否有机会禁用已完成的序列容器并运行失败的容器?

解决方案

您可以使用 SSIS 中的 CHECKPOINT 文件功能来自动仅运行控制流任务中失败的容器.它在 SSIS 中开箱即用.您可以在包中进行配置.

Suppose I have a SSIS package which is having almost 20 sequence containers and while running the job, a few sequence container got completed successfully but a few fail. So, here I want an automated SQL query to disable the completed sequence container and enable the failed sequence container so that if I run the package again, then it will run only failed sequence container.

Is there any chance to disable the completed sequence container and run the failed one?

解决方案

You can use CHECKPOINT file feature in SSIS to automatically run only the failed containers in the control flow task. It is available out of the box in SSIS. You can configure it in the package.

Read more on Checkpoint usage & Restart packages using checkpoint on MSDN

这篇关于使用 SQL 查询禁用 SSIS 中的序列容器?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！