Skip to Content
0

error handling for row count

Nov 07, 2017 at 06:41 AM

37

avatar image
Former Member

Hi

when I run the job it complete successfully but it have error message because the job was not able to processed some data. Suppose I have 100 rows but 90 rows only processed to target. Now my requirement is get count of source table and the processed data and send mail if source count and processed count is matched or mismatched using smtp.

How i can achieve this.......

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Arun Sasi Nov 08, 2017 at 04:27 AM
0

Use the audit Function in Data Services. You can use count() function and match the count between Source and target table.

Regards

Arun Sasi

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Arun ,

Thanks for the information. Please explain how to do audit. I found the audit option and used the count option.

Thanks and Regards

Jyoti

0

Refer to below link

Auditing in Data Services

Also refer Data Services Designer Guide

Regards

Arun Sasi

0