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?