error handling for row count

[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.......

[former_member198401 · Accepted solution]

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

Regards

Arun Sasi

[Former Member · Accepted solution]

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

[former_member198401 · Accepted solution]

Refer to below link

Auditing in Data Services

Also refer Data Services Designer Guide

Regards

Arun Sasi