sql server dts: Execute SQL Task -- sql server dts

Execute SQL Task

EG
4/29/2004 9:46:10 AM

sql server dts: I am using a SQL Task in my DTS package. If the SQL being executed fails, I would like to proceed to a specific task. If it suceeds, I would like to proceed to another. However, if the SQL raises an error, the step fails and none of the other steps run. Fail package on first error is not selected. Am I doing something incorrectly, or is this the normal behavior

Thanks in advance for any assistance

Re: Execute SQL Task

Ilya Margolin
4/29/2004 1:39:15 PM

Check work flow properties of this task on the subject of "Fail package on
this step failure".

[quoted text, click to view]
I would like to proceed to a specific task. If it suceeds, I would like to
proceed to another. However, if the SQL raises an error, the step fails and
none of the other steps run. Fail package on first error is not selected.
Am I doing something incorrectly, or is this the normal behavior?
[quoted text, click to view]