BODS - mail with error notifications

[Former Member]

Hi everybody,

I use BODS ver 4.2 and SQL Server 2012. I created Job which contain Catch and try and one DataFlow. DataFlow takes data from csv files and transform into target table. I made some error in DF (change data type from date to int) and of course the process failed.

Is it possible to get mail notification about error (error text also + name DF)? This error comes from BODS -> Log and choose
see attached file bods-error.jpg

Kind Regards

[Former Member]

Just use the the built-in functions error_message() and / or error_context(). For more details check the Reference Guide.

[Former Member]

Hi Dirk,

thank you for your answer. Maybe I didn't write it clearly but I'd like to get in mail error message (as I attached in screen)
How can I pass error message into mail?

Regards

[former_member187605]

Yes. Use smtp_to or mail_to built-in function. Check the SAP Data Services Reference Guide for details.