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

[Phongmanee]

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

[alchemiz]

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:

Thanks,
EmEm