DSXchange

Hi

When i am load the records using Update existing or insert new rows.

Job is finished successfully. But i am getting warning.

This update action 'update or insert' is not compatible with parameter array binding. Array Size property will be set to 1.

This issue is resolved...

Array size. The input array size. The default is 50 rows that are cached before being written to the database. The array size value should be an integer greater than or equal to 1.

Note: If a table that is being updated is also being used for reference lookups, the Array size must be 1 so the updates can be referenced.

Transaction size. The number of rows that the plug-in processes before committing a transaction to the database. The transaction size should always be a multiple of the array size. The default is 100. The transaction size should be an integer greater than or equal to 0. A value of 0 means that the transaction will not be committed until all rows have been processed.

Right, seeing as how it must be 1 for the process to work, you eliminate the warning by setting it (the Array Size) to 1. Problem solved.