September 9, 2005 at 3:48 pm
Hello,
I am using an Exec SQL task in DTS that executes a procedure. How can I force the Exec SQL task to complete successfully even if the stored procedure returns an error? Is there another way to run a stored procedure inside of a DTS package that will allow me to ignore errors? The procedure is just running and not writing anywhere, so I don't believe setting "max errors" in a transformation would work.
Anyone have any ideas? Any help would be greatly appreciated.
September 12, 2005 at 11:16 am
You could change the workflow from the Execute SQL task to "on completion" rather than "on success". Then the folowing tasks would execute whether the stored procedure succeeded or not.
Greg
Greg
September 12, 2005 at 11:21 am
Thanks for the response.
Yes, I could change workflow, however, I am running the DTS package from a job, and I do not want the job to fail (and page the DBA's) when one execute sql task fails. So ultimately, I was hoping there was a way to "trick" DTS to think it completed successfully (and report that to SQL Agent) so that the job does not send failure notifications.
September 12, 2005 at 11:59 am
So, you want the job to think that the package succeeded.
Okay, try this. Open the package, then look at the Logging tab on Package Properties. Make sure "Fail package on first error" is unchecked. The package will complete with a successful status regardless of any task failures. That should keep your job step from failing.
Greg
Greg
September 12, 2005 at 1:15 pm
No dice. If "Fail package on first error" is unchecked, and the package fails, the job fails as well.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply