Total number of inserted/updated records to send
IS there a way to get total number of inserted/updated records to send it in the email?
Can I store it in a context variable somehow or get it from context to add it in the email?
-
Solution:
This can be achieved by creating two variables in Put Context Var activity for OperationCount and ErrorOperationCount. This will store the count of records inserted and count of erroneous records in those variables.
The number of records are stored in these variables(OperationCount & ErrorOperationCount) after the Database Target activity is executed and it is our back-end process in which we store values for these variables.
Please place the Put Context Var activity after Database Target activity and create the variables that we have described in our last response then the values will be stored in the respective context variables. In your case you have to place two Put Context Var each before the mail activity, one for operation count and other for Error Operation Count in the error intermediate path.
These variables can be further used in the Mail notification activities for fetching the values for operation count.
0
Post is closed for comments.
Comments
1 comment