The Definitive Guide to Data Quality
Is there any truncation error printed on console? Have you tried to use "Rejects" row from tSalesforceBulkExec to see if there is any rejected row?
Hi and thanks so much for the replies. There are no truncation errors present in the Talend console. I am outputting the results of the tSalesforceBulkExec component to success and error files. The issue is not really with some rows failing and some completing successfully, it's just that only 65k rows make it Salesforce. In the Salesforce bulk data load monitoring tool it shows 65k rows being processed, some failing and some successful and the results are consistent with the tSalesforceBulkExec output that I can see in Talend. The strange thing to me is that when I process a file with >200k rows with tSalesforceBulkExec, exactly 65k rows make it to the bulk load job in Salesforce. I'm beginning to think that maybe Salesforce has limited the data on input, but really wanted to see if any others have also seen this same behavior. Thanks, cheers!