MS SQL Server DTS - Unable to enlist in the transaction.

Author

Unable to enlist in the transaction.

TobyRiley

2005-09-26, 7:23 am

Re-post from Jan 20, 4:27 pm - still can't fix it!!

Hi,

When i execute the same DTS job on another server not running SQL Server I
get the following errors. But if i run the job on the same server as the SQL
Server it works. Or if the DTS transactions are turned off it works. Both
servers belong to the same domain.

This is driving me mad - please if anyone has any pointers. I didn't get a
solution last time I posted.

Regards

Toby.

C:\Documents and Settings\Administrat
or>DTSRUN /SX3136\SQL2000S_1 /Usa /Psa
/NFFCSVIMPORT_LIVE
DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSActiveScr
iptTask_1
DTSRun OnFinish: DTSStep_DTSActiveScr
iptTask_1
DTSRun OnStart: DTSStep_DTSExecuteSQ
LTask_1
DTSRun OnError: DTSStep_DTSExecuteSQ
LTask_1, Error = -2147168246 (8004D00A)
Error string: Unable to enlist in the transaction.

Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 1100

Error Detail Records:

Error: -2147168246 (8004D00A); Provider Error: 0 (0)
Error string: Unable to enlist in the transaction.

Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 1100

Error: -2147168246 (8004D00A); Provider Error: 0 (0)
Error string: Connection 'Clients Import' for Task
'DTSTask_DTSExecuteS
QLTask_1' does not support joining distributed
transactio
ns or failed when attempting to join. Unable to enlist in the transaction.

Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 5300

Error: -2147168246 (8004D00A); Provider Error: 0 (0)
Error string: New transaction cannot enlist in the specified transaction
coordinator.
Error source: Microsoft OLE DB Provider for SQL Server
Help file:
Help context: 0

DTSRun OnFinish: DTSStep_DTSExecuteSQ
LTask_1

Error: -2147220440 (80040428); Provider Error: 0 (0)
Error string: Package failed because Step 'DTSStep_DTSExecuteS
QLTask_1'
failed.
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 700

Allan Mitchell

2005-09-26, 9:23 am

As I said the last time you posted I can only see the connection to
which you are pointing does not support transactions or the MSDTC is not
started on that Server. Check the different settings between these two
servers.

Allan

"TobyRiley" < TobyRiley@discussion
s.microsoft.com> wrote in message
news:F9B5F36D-3704-4B14-BABE- 27EC6200A515@microso
ft.com:

> Re-post from Jan 20, 4:27 pm - still can't fix it!!
>
> Hi,
>
>
> When i execute the same DTS job on another server not running SQL Server I
> get the following errors. But if i run the job on the same server as the SQL
> Server it works. Or if the DTS transactions are turned off it works. Both
> servers belong to the same domain.
>
> This is driving me mad - please if anyone has any pointers. I didn't get a
> solution last time I posted.
>
> Regards
>
> Toby.
>
> C:\Documents and Settings\Administrat
or>DTSRUN /SX3136\SQL2000S_1 /Usa /Psa
> /NFFCSVIMPORT_LIVE
> DTSRun: Loading...
> DTSRun: Executing...
> DTSRun OnStart: DTSStep_DTSActiveScr
iptTask_1
> DTSRun OnFinish: DTSStep_DTSActiveScr
iptTask_1
> DTSRun OnStart: DTSStep_DTSExecuteSQ
LTask_1
> DTSRun OnError: DTSStep_DTSExecuteSQ
LTask_1, Error = -2147168246 (8004D00A)
> Error string: Unable to enlist in the transaction.
>
>
> Error source: Microsoft Data Transformation Services (DTS) Package
> Help file: sqldts80.hlp
> Help context: 1100
>
>
> Error Detail Records:
>
>
> Error: -2147168246 (8004D00A); Provider Error: 0 (0)
> Error string: Unable to enlist in the transaction.
>
>
> Error source: Microsoft Data Transformation Services (DTS) Package
> Help file: sqldts80.hlp
> Help context: 1100
>
>
> Error: -2147168246 (8004D00A); Provider Error: 0 (0)
> Error string: Connection 'Clients Import' for Task
> 'DTSTask_DTSExecuteS
QLTask_1' does not support joining distributed
> transactio
> ns or failed when attempting to join. Unable to enlist in the transaction.
>
>
> Error source: Microsoft Data Transformation Services (DTS) Package
> Help file: sqldts80.hlp
> Help context: 5300
>
>
> Error: -2147168246 (8004D00A); Provider Error: 0 (0)
> Error string: New transaction cannot enlist in the specified transaction
> coordinator.
> Error source: Microsoft OLE DB Provider for SQL Server
> Help file:
> Help context: 0
>
>
> DTSRun OnFinish: DTSStep_DTSExecuteSQ
LTask_1
>
>
> Error: -2147220440 (80040428); Provider Error: 0 (0)
> Error string: Package failed because Step 'DTSStep_DTSExecuteS
QLTask_1'
> failed.
> Error source: Microsoft Data Transformation Services (DTS) Package
> Help file: sqldts80.hlp
> Help context: 700

Sponsored Links