Kingsway Batch Size / Ignore Error

(0) Share

Report

Posted on by Paulo

Hi,

I am creating a POC to load data into the contacts entity from a CSV file. A few records have "bad" data, which is something that is not relevant for the POC at the moment.

My POC is more about load speed into a CRM Online instance, I am using Kingsway Dynmamics CRM Destination component for SSIS. If I set Batch Size to 1 and Error Handling to Ignore Error as follow, the package runs fine, although some records would cause the load to fail.

But if I change Batch Size to anything greater than 1, the package will fail. The error message indicates that some text file is trying to be inserted into a Date field, which is a known problem with the file, due to an extra comma that a very small percentage of the records have, again, I am not trying to resolve this problem right now.

Have anyone seen this behavior before?

Thanks

*This post is locked for comments