求助!!SSIS 用事务实现回滚
现在我为了实现回滚,把这两个数据流放到一个序列容器里,把序列容器的TransactionOption设置为Requied,2个数据流任务和包的TransactionOption都还是Supported,这样执行的话就会出现错误如下:
[OLE DB 源 [2301]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "CacheDB" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
[SSIS.Pipeline] Error: component "OLE DB 源" (2301) failed the pre-execute phase and returned error code 0xC020801C.
结果如下图所示:
我的Distributed Transaction Coordinator 服务是已启动的。
我的DTC安全配置如下图:
大神们能告诉我为什么会出错吗?还有应该怎么实现这样的回滚啊?