October 8, 2009 at 8:31 am
HI All
I have an SSIS that includes an Execute Process Task. When I run the SSIS package from a job, the job failed, but the Execute Process Task does not run. I get the following text included in the message form the job history as it relates to the Execute Process Task:
Source: Run RMProductImport Execute Process Task
Description: In Executing "j:\Datafeeds\FOProdImport\RMProductImport.exe" "RMPROD" at "",The process exit code was "-1" while the expected was "0". End Error Error: 2009-09-30 06:20:17.80 Code: 0x00000004 Source: C heck No Files to Process Script Task Description: The Script returned a failure result. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 6:00:01 AM Finished: 6:20:17 AM Elapsed: 1216.39 seconds. The package execution failed. The step failed.
. Can anyone help? plzz...
October 8, 2009 at 8:34 am
Try specifying a UNC path rather than a drive letter in the path to the exe.
October 8, 2009 at 9:50 pm
I'd start by trying Phil's suggestion, since mapped drives can be unreliable. But since you're getting a return code from the executable, the problem may be related to the executable or the syntax you're using in the Execute Process task. Can you call the executable manually using the same syntax and parameters?
hth,
Tim
Tim Mitchell
TimMitchell.net | @tmitch.net | Tyleris.com
ETL Best Practices
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply