Skip to Content
avatar image
Former Member

error handling for row count

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Nov 08, 2017 at 04:27 AM

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

    Regards

    Arun Sasi

    Add comment
    10|10000 characters needed characters exceeded