Thank you for providing additional details.
It has been identified that there are some bugs with the new Salesforce connector V2 in Azure Data Factory. As a workaround, you can try using the legacy Salesforce connector until the issues with the new connector are resolved. Please refer to Bhargava's suggestions, which were shared in the same link.
However, it's important to note that using the legacy connector may not be a long-term solution, as it may be deprecated in the future. We recommend keeping an eye on updates from Microsoft and Salesforce regarding the new connector and its issues.
I hope this information is helpful. Please let me know if you have any further questions or concerns.