Rank: Member
Joined: 3/6/2018 Posts: 28
|
Hi All,
I am trying to insert records in sql database from a csv file. How can we get count of records which are failed while inserting in database because of some sql errors like Referential integrity failed.
Or How to add records which are failed to insert in database in file.
Please help.
|
Rank: Newbie
Joined: 10/8/2018 Posts: 2
|
I find error handling on Mapforce very hard to understand (or just poor), but I guess one way would be to add more steps after your insert function.
Query the Table you inserted into where the records you wanted to insert do not exist (like a left outer join in SQL), then output that to a file.
|