Hi KP,

The user account & proxy account are Windows account which is on the same domain as the server. The DTS package is stored under SQL server.

Thankyou.

Yes, everything is same, Iam using same UNC Path.  Looks like the problem is permissions with CreateProcessTask.

Thankyou.

Yes that option is already unchecked.. One more thing i found, I created a job owned by non-sys admin, which directly runs the .bat file, it runs fine using proxy.

Only...

KP,

I agree.  But in this case the user would like to run the job manually whenever needed.  Thats the reason we have setup proxy also. But the job which is...

When the job is owned by proxy its going to run under sqlagent service account which works fine..

When the job is owned by non-sys admin (users), the job should run...