Hi,

In my DM flow I have indicated I want record logging of the accepted transactions. I use this to make a summmary report of the processing that took place by making and emailing a report using the synonym/dataset of the accepted transactions.

This works fine generally, but I now bumped into an issue. When there are no records processed the dataset of accepted transactions of the previous run remains. I would expect it would result in an empty dataset. I did uncheck "Stop if 0 rows selected" so the flow does not give an error, but how do I arrange that the dataset of accepted transactions is empty?

This message has been edited. Last edited by: FP Mod Chuck,

I would suggest writing a one line stored procedure to delete the accepted transactions file and add it to the process flow before the data flow.