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
Problem to catch error codes in STP stage
Moderators: chulett, rschirm, roy