ExecuteProcess Task fails when package runs as job
-
Hi all,
I have an ssis package that runs under as a SQL Job. It completes 95% of the job, but fails on the final step - an execution of a batch file.
Error -
Message
Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 17:29:55 Error: 2009-04-30 18:40:00.56 Code: 0xC0029154 Source: COMBINE Execute Process Task Description: File/Process "combine.bat" is not in path. End Error Error: 2009-04-30 18:40:00.59 Code: 0xC0024107 Source: COMBINE Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 17:29:55 Finished: 18:40:00 Elapsed: 4205.2 seconds. The package execution failed. The step failed.
Now I set DelayValidation to TRUE but that didn't help.
This step passes 2 expressions from variables - the workingdirectory and the name of the executable. This seems to be the issue maybe?
Although I'll leave this question here I just had a thought that maybe I need to put the full path in the executable property AND in the working directory...I'll try that but the question remains in the meantime!
Cheers
-
Shark Energy (5/1/2009)
Hi all,I have an ssis package that runs under as a SQL Job. It completes 95% of the job, but fails on the final step - an execution of a batch file.
Error -
Message
Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 17:29:55 Error: 2009-04-30 18:40:00.56 Code: 0xC0029154 Source: COMBINE Execute Process Task Description: File/Process "combine.bat" is not in path. End Error Error: 2009-04-30 18:40:00.59 Code: 0xC0024107 Source: COMBINE Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 17:29:55 Finished: 18:40:00 Elapsed: 4205.2 seconds. The package execution failed. The step failed.
Now I set DelayValidation to TRUE but that didn't help.
This step passes 2 expressions from variables - the workingdirectory and the name of the executable. This seems to be the issue maybe?
Although I'll leave this question here I just had a thought that maybe I need to put the full path in the executable property AND in the working directory...I'll try that but the question remains in the meantime!
Cheers
Use the full path. Also don't forget to use quotes around it, in case the path contains space. Let us know how it goes.
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply