Please Help - Transactions won't work in DTS if executed from another machine

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Toby (toby_at_nospam.com)
Date: 01/20/05 

Date: Thu, 20 Jan 2005 16:27:13 -0000

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.

This is driving me mad - please if anyone has any pointers.

Regards

Toby.

C:\Documents and Settings\Administrator>DTSRUN /SX3136\SQL2000S_1 /Usa /Psa
/NFFCSVIMPORT_LIVE
DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSActiveScriptTask_1
DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1
DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1
DTSRun OnError: DTSStep_DTSExecuteSQLTask_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_DTSExecuteSQLTask_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_DTSExecuteSQLTask_1

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

C:\Documents and Settings\Administrator>

Relevant Pages

  • Unable to enlist in the transaction.
    ... When i execute the same DTS job on another server not running SQL Server I ... Unable to enlist in the transaction. ... Help file: sqldts80.hlp ...
    (microsoft.public.sqlserver.dts)
  • Re: Unable to enlist in the transaction.
    ... 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. ... Help file: sqldts80.hlp ... Error string: New transaction cannot enlist in the specified transaction coordinator. ...
    (microsoft.public.sqlserver.dts)
  • Re: dtsrun - on another users computer with out installing more software on the machine
    ... changed this to the server name and now its not finding the files that I ... Microsoft Data Transformation Services Package ... Help file: sqldts80.hlp ... > Your DTSRUN command refers to the SQL Server. ...
    (microsoft.public.sqlserver.dts)
  • Re: dtsrun from remote server
    ... SQL Server does not exist or access denied. ... So what is the server name value used in the connections for the steps/task that have failed, and can it be resolved from the machine used to call DTSRUN? ... Microsoft OLE DB Provider for SQL Server ... Help file: ...
    (microsoft.public.sqlserver.dts)
  • Re: Networking a printer through a router
    ... What is the LPD server? ... Would that be the address of my router? ... The help file says it is the name of the ...
    (comp.os.os2.networking.misc)