Forum Discussion

Phongmanee's avatar
Phongmanee
New Contributor
3 years ago

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

pipeline

1 Reply

  • alchemiz's avatar
    alchemiz
    Contributor III
    3 years ago

    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