Transaction problem (pg298)
I have multiple packages and I want one transaction
I follow all book's steps but when I execute, the transaction fails whith these messages
In a package:
Error: An OLE DB error has occurred. Error code: 0x80040E14. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "The Microsoft Distributed Transaction Coordinator (MS DTC) has cancelled the distributed transaction.
Error: The AcquireConnection method call to the connection manager "Ware House_Dst" failed with error code 0xC0202009.
I read in other forums many tips... but nothing
(service started, firewall off)
someone can help me?