Get problem using SQL Server Delete, delete successful but only first row completed

I build pipeline with json generator to build table list row. Then, SQL Server Delete snap use table name from each row to be executed.
I tried validation. the result is success for each row. But only first row return number of record deleted. Other rows were also successful but 0 record deleted. I tried reorder table row in json generator. Only first row really executed.

** I tried changing from SQL Server Delete to SQL Server Execute, all row process succesfully as they should be. But why delete snap didn’t work?

Thanks,
PJ

Hi PJ,

Good day, kindly share the json format that you used, the object should be an array so that each table will process a streaming document

Example:

image

image

image

Thanks,
EmEm