Error in Azure Data factory

Question

Failure happened on 'Sink' side. ErrorCode=DelimitedTextColumnNameNotAllowNull,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The name of column index 3 is empty. Make sure column name is properly specified in the header row.,Source=Microsoft.DataTransfer.Common,'

Answer 1

Are you trying to do a copy with headers taken from your source file? Your source has not provided a heading for at least one column...

Answer 2

Hi @Felipe Castaneda ,

Welcome to Microsoft Q&A forum and thanks for posting your query.

As @Ryan Abbey pointed, looks like your source data is missing a column or having an empty column name.

I assume that you are using a copy activity and doing auto mapping in it. If that is the case, then it is by design behavior that when there is an empty column name in copy activity source then it will throw this error.

You can validate the schema structure by clicking on Copy activity source and doing a preview of the source dataset from copy activity level. This would give you hint to figure out where the empty column is and fix it accordingly.

For more info, please refer to this stackoverflow thread where a similar issue was discussed: https://stackoverflow.com/questions/65871486/azure-adf-copy-activity-with-trailing-column-delimiter

Hope this info helps. Do let us know if you have further query.

----------

Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.