Get problem using SQL Server Delete, delete successful but only first row completed
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-08-2022 01:28 AM
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-13-2022 06:45 PM
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
