SSIS error with transactions and logging -
11-14-2006
, 05:42 AM
I have defined a transaction on a container within a loop container.
All works fine until I activate logging with Sql Server provider.
Then, on second execution of the inner (transacted) container, an error
occurs:
Distributed transaction completed. Either enlist this session in a new
transaction or the NULL transaction.". 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.".
With no logging or any other logging provider it works fine !
Logging is defined with a different connection than the "working" connection
and with a different database on the same server.
The same problem was here already reported on 7/10/2006 by Martin Schou, but
no answer to the problem was given. |