November 24, 2005 at 3:16 am
Hi,
I have just received an error on running an 'Execute Process Task' package that I have never seen before. I can find no documentation on this error. Can anyone help ?
Error Description: CreateProcessTask 'DTSTask_DTSCreateProcessTask_13': Process returned code 5, which does not match the specified SuccessReturnCode of 0.
Does anyone know what an 'error 5' is?
If you need any further details, please feel free to ask and I'll do what I can to provide them.
Thanks in advance,
Mike.
November 25, 2005 at 3:16 am
Error 5 is typically a permission issue, can be caused by a missing file, share, etc. I have also seen this when the account the task is running under does not have the permission to access the object.
Does this task access a file?
Andy
November 25, 2005 at 3:24 am
Yes. At least part of the task copies files from one Windows server to another using rsync.
November 25, 2005 at 10:08 pm
Then I take it that you have verified that the files exist as described in your task, right? If so then verify that the account that the task runs under has the permission to see/use the file share and access the file. Especially for the destination directory.
You should also verify that any object that the task references is available to the account that it runs under.
When you design you are running under your login account, vs when the task is scheduled or run from another application. You are running the task using a different account, like the SQL Server Agent service account.
If the task is using SQL Server Agent and the SYSTEM account, then grant the SQL Server computer account the appropriate access to the file/folder/share/object and you are in effect granting the local SYSTEM account the permission.
One of these is the cause, I'll bet.
Andy
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply