DTS cannot file the file 1

[mingus]

I run the dtsrun command on a couple machines and works fine.

I run it on another and it says it cannot find the file.
Enterprise manager says the same thing, although it can find the database and everything else just fine.

Anybody have a clue? (I just spent an hour trying to find the answer, I am sure somebody else has had this probelm)

thanks!

 

[RickCole]

Reinstall the SQL Server lateset service pack on the machine which can not find the file.

Rick.

 

[tlbroadbent]

Is the file on the same server or another server? If on another server, does the SQL Agent login have permissions to view the server and directory where the file resides. When you run DTSRUN from the command prompt, it runs under the Windows logon account. When you run it from a JOB, it uses the SQL Agent account. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[mingus]

Doh! I knew that, darn memory, but thanks for reminding me.