question

kalpu234 avatar image
kalpu234 asked

Unable to run DTS package from Sql server agent job

I run into The problem I can execute the DTS package by command line in sql server 2008r2 but when I try to run the same package from SQL Server job I got the following error. . Message Executed as user: Domain\service-account. The process could not be created for step 1 of job 0x number (reason: The system cannot find the file specified). The step failed. Can somebody helping me out on the issues? Note : Service account running SQL Server Agent is the member of the Administrative group.
dtssql-server-agent
3 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Is there a file on a mapped drive that is specific to your account but not the SQL service account? Are you using a network share for which the SQL service does not have permission? Being an administrator on the machine will not take care of mapped drives or networked resources
1 Like 1 ·
Thank you KenJ for your reply. I am using local drive and the the package is executing from the command line using DTsrun. Even I tired to run the job with command line with DTSrun only it is giving me the same error Message Executed as user: Domainservice-account. The process could not be created for step 1 of job 0x number (reason: The system cannot find the file specified). The step failed.
0 Likes 0 ·
kalpu234 avatar image
kalpu234 answered
Thank you Sqlaj 1 and KenJ after restarting the sql server agent it starts workig fine.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sqlaj 1 avatar image
sqlaj 1 answered
Are you on a 64-bit System? When executing the package via commandline are you executing from the correct version of DTExec? Make sure the path to the package is correct.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.