Multiple Transactions
Hi all
I am trying to run multiple transactions in one of my packages. In particular, I am trying to run one transaction in the Control Flow and another transaction in the OnPreExecute Event (for the package itself).
To achieve this, I have a sequence container in each. Each sequence container has TransactionOption set to "Required". The Control Flow and the OnPreExecute containers each have the TransactionOption set to "Supported".
When I run this package, the Sequence Container in the Control Flow fails and I get the error shown below.
However, If I subsequently disable the Sequence Container in the OnPreExecute Event and re-execute the package, the Sequence Container in the Control Flow works fine!.
Any help is much appreciated.
Jays :-)
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction.".
