When trying to insert my records into salesforce, I'm receiving the following error -
EXCEEDED_ID_LIMIT: record limit reached. cannot submit more than 200 records into this call
This hard limit is set by Salesforce to send 200 records at a time as part of the query method call when the query is a simple Select * (as part of SOQL). The Web service is not meant for bulk extraction.
The bulk loading or extraction needs to be done carefully and should use a filter condition on the database source query such as modified date to pull only the incremental changes from the database that need to be sent to Salesforce.