dbTalk Databases Forums  

SSIS error with transactions and logging

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss SSIS error with transactions and logging in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
rweiss
 
Posts: n/a

Default 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.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.