MS SQL Server DTS - Error while calling DTS package from Serviced Component

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Error while calling DTS package from Serviced Component

Navnit

2006-03-24, 7:39 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

Sponsored Links