Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  DTS Package in Clusters

Author  Topic  san_spy Starting Member 6 Posts Posted - 2005-08-15 : 13:52:04 HI, We have a couple of DTS packages in a 2 node cluster. We have a problem like when the database is in its primary node then those dts jobs gets runs. But when the database is failed over then those dts jobs fails(When I run the package directly it runs but not as a job). The error I find is Executed as user: PP\svcentsqlcl. The process could not be created for step 1 of job 0xF642B049F90FC045A1577BC55BFFEA5A (reason: The system cannot find the file specified). The step failed. In the above PP\svcentsqlcl user is a domain user and service account under which the SQL Server runs in both the nodes. It has all rights. I have even tried to recreate the job in the fail over node. It does not work either. Can you please let me know if you have any ideas on this. Except this DTS job all other jobs run fine. With Smiles Santhosh