Problem to catch error codes in STP stage

DSDexter · Post by **DSDexter** » Mon Mar 24, 2008 4:26 am

Hello,

I am using the stored procedure stage in my job as a target.

DB----->Transformer----->STPstage.

I want to catch the user defined exceptions in the procedure and display them in my director log. I have defined the error codes in the Error Code tab,Under warnings (As I want to display them as warnings). but when i run the job, I am not able to view the warnings in my job log.

Example codes I specified : 00001 02291 29279.

The codes are specified in exactly the same order as displayed above.

I even specified them in the Fatal error section but nothing fruitfull

Any help in this regards will be appreciated.

Thanks in advance
DSDexter

Aquilis · Post by **Aquilis** » Mon Mar 24, 2008 8:13 am

I too have faced same issue with STP Stage once.
So by that time i was not having enough time to do any workarounds R&D work.
please give us some inputs regading the same,who have implemented this scenario before.So that i too can come to know what the mistake i have done before.

Thanks,