Problem to catch error codes in STP stage
Posted: 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
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
![Rolling Eyes :roll:](./images/smilies/icon_rolleyes.gif)
Any help in this regards will be appreciated.
Thanks in advance
DSDexter