如何回滚包 [英] how to rollback a package

问题描述

如何在ssis中回滚包

how to rollback a package in ssis

推荐答案

我建议的第一种方式要回滚ssis etl包，您需要在Event处理程序中定义包级事务，并将代码放回到Script任务中。



另一种方法是放置所有任务使用单个Sequence Containder并启用容器级事务，然后为所有其他任务设置事务属性以支持由容器启动的此主事务，现在所有任务将在单个事务中执行，如果发生任何故障，则它将被回滚。



问候，

Mubin

Hi,

First way i am suggesting To Roll Back the ssis etl package you need to define package level transaction in Event handler and place your code to roll back in Script task.

Anotherway is to Place all Tasks withing single Sequence Containder and enable container level transaction and then set transaction property for all other tasks to support this main transaction initiated by container, now all tasks will execute in single transaction and if any failure occur then it will be roll backed.

Regards,
Mubin

我们需要执行以下步骤才能达到您的要求：



1.我们应该将父级交易选项设为必需（这只是我们在CFT中的序列容器和支持的子级事务选项d（序列容器下可用的所有其他任务）。





2.此外，转到查看本地服务并搜索分布式事务协调员并重新启动该选项并关闭它。



3.接下来，您需要来到您的包并执行它，您可以看到包中的任何任务失败，其余任务将回滚。 />






谢谢和最诚挚的问候，

Durga。

Hi,

We need to perform the following steps in order to achieve your requirement:

1. We should make the parent level transaction option to required (which is nothing but our sequence container in CFT) and child level transaction option to supported (all other tasks available under the sequence container).


2. Also, go to the view local services and search for Distributed Transaction Co-ordinator and restart the option and close it.

3. Nextly you need to come to your package and execute it where you can see any tasks is failed in the package, rest of the tasks will rollback.



Thanks & Best Regards,
Durga.

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