There is a column at the end and that is coming empty from the SFTP. But there is an extra comma in the SFTP CSV which is causing this issue.
Can we somehow trim the extra comma(delimiter) which is causing failure in the mapping?
Adding this for your reference to understand my issue.
The complete error message is as follows:
ErrorCode=DelimitedTextMoreColumnsThanDefined,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Error found when processing 'Csv/Tsv Format Text' source 'rma_20211022122932_000001.csv' with row number 2: found more columns than expected column count 9.,Source=Microsoft.DataTransfer.Common
Thanks and Regards,