Error message:
The number of row value expressions in the INSERT statement exceeds the maximum allowed number of 1000 row values.
Problem:
As written... INSERT statement exceeds the maximum allowed number of 1000 row values.
Surprised, but INSERT statement using 'VALUES' (not insert with a select) - have limitation of 1000 inserted records.
Solution:
Anything that will use INSERTs with maximum 1000 records: separate to few INSERTs, insert the new data to temp table and insert using select from the temp table and so on.
