DTS - Stored Procedures

[vechalapu]

Hi,

I am executing SQL task for executing Stored Procedures. Whenever Stored Procedures abends due to fatal error i.e. invalid column name is not being recongised by DTS as an error instead it says it is successful. Is there any way to trap fatal errors from Stored Procedures when executed through DTS.

Thanking You,
Babu Vechalapu

 

[DLanouette]

No, not really. All dts cares about is that it was able to run the sp. It doesn't care if it failed or not.

What you can do is trap the error (with &quot;if @@Error <> 0 goto someline&quot; after EVERY statement) and then return the error code. Because, you can check this in DTS (atleast in sql 2k) by saving the output to a global

Then you can put a vbscript step to check the return value and do whatever.

HTH


______________________________
- David Lanouette
- Lanouette Consulting, LLC
- DLanouette@Computer.org

 

[vechalapu]

Hi,

From my experience using SQL task, it is not possible to trap fatal errors. I could trap all errors in stored procedures by executing stored procedurtes using SQL Server osql utility.