February 2, 2010 at 4:01 pm
I have a process task which is fails has a workflow in the SSIS package and these subsequent tasks get performed ok (greeen)
However when I run as a step in a job then although the workflow for the error workflow gets performed SQL Server Agent reports the step failed with
The process exit code was "1" while the expected was "0". End Error DTExec: The package execution returned DTSER_FAILURE (1)
How do I stop either SQL Server Agent fro
m reporting job failed or modify the package to still route the process task for failure different to success but not to say failed.
I have another task (FTP) which has the same logic and works ok, but this problem is with how to handle a failure from the process task.
Any Ideas?
February 3, 2010 at 8:55 am
There is a property in the execute process task called successvalue. It sounds like you have it set to 1 instead of the default of 0.
February 3, 2010 at 9:37 am
Hi,
I haven't changed from defaults so its still set to 0.
I am now trying to get it force success as result and capture output into a variable which I then check but I still get overall package failure even though it looks ok.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply