0

I'm using a copy data activity to move data from excel files to a db. In the mapping I added the column names that should come in the excel file. Sometimes files come with columns without a name and the activity fails with error:

ErrorCode=ExcelInvalidHeader,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Invalid excel header with empty value.

Is there a way to ignore the columns with no name and keep using the column's names for the mapping? I'm aware that using column numbers could "fix" this issue but I need to use the column's names.

Improve this question
New contributor
GAEL LoretoMiranda is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
Related questions
0
Azure ADF Copy Activity with Trailing Column Delimiter
0
Change of table column name not reflected in Azure Data Factory after schema imports, saving, publishing
0
ADF Copy with Polybase from Parquet to SQL DW Failing with error: recordReaderFillBuffer
Load 5 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.