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>

But you have the DTS dlls right?

Is, On the local to you box, the MSDTC started?


--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Toby" <toby (AT) nospam (DOT) com> wrote

Yes they are started and both are configured for network transactions. But
the only thing i can think of is they are members of a workgroup not a
domain. Can authentication problems cause this, but then again i'm running
this under sa account.

regards

Toby
"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Anybody have any ideas ?

Regards

Toby

"Toby" <toby (AT) nospam (DOT) com> wrote

yeah do you have the same version of the DLLs on both machines?

you have to run SP3 on client machines in order to have the latest client tools.. right??

--
Message posted via http://www.sqlmonster.com