SQL Jobs failing to run a DTS
-
one of our server will not run any DTS packages from a SQL Agent Job. The job is set to run under the Doman\SQLAdmin user, this user has full rights on the box .
The error message from one of the Job that has failed is as follows:
Executed as user: Domain\sqladmin. The process could not be created for step 1 of job 0x88F3B8A585AC874798E60566869C0633 (reason: The system cannot find the file specified). The step failed.
This error is on all jobs that are running a DTS Package.
Thank
Craig
-
Check out this MS article:
It says that SQL Agent may not be able to find DTSRun.exe.
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor -
can you explain what's happening in step 1 of your package.
If it is fileaccess, your user Domain\sqladmin may not have access-authority to that file.
If you want to check it : logon to the server as Domain\sqladmin, open the dts-gui , open the dts-package and push the execute button.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
Thanks Kathi,
it looks like the problem is that the server is missing the registry key with the path to the DTSRun.exe file.
Thanks for the help.
Craig
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply