dbTalk Databases Forums  

Error while calling DTS package from Serviced Component

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


Discuss Error while calling DTS package from Serviced Component in the microsoft.public.sqlserver.dts forum.



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

Default Error while calling DTS package from Serviced Component - 03-24-2006 , 03:50 AM






Hello Guys,

We are calling a DTS package from a Services Component "A" which has
transaction attribute set to Requires New. When the DTS package is being
invoked for the .NET code, the application hangs and we receive a
“Distributed transaction completed. Either enlist this session in a new
transaction or the NULL transaction.” Exception. The DTS package is
configured to join an existing transaction if present.

We have also tried to set the transactional timeout property within COM+ to
a substantial value, it still didnt work. Hope someone has faced a similar
problem and found a fix for it.

Thanks in advance

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.