The name of column index 9 is empty ADF

• erics44

  SSCertifiable

  Points: 6311

  More actions

  June 3, 2024 at 2:27 pm

  #4425921

  Hi

  I am brand new to Data Factory

  I am getting the following error when doing a simple copy data task in Azure Data Factory.

  Message=The name of column index 9 is empty. Make sure column name is properly specified in the header row.,Source=Microsoft.DataTransfer.Common

  Yet the column index 9 does not exist. If I look at the mapping in my Copy Data transform there are only 8 columns, my SQL table only has 8 columns and I preview the data it only has 8 columns.

  All 8 columns have names.

  Can anyone help please.

  Thanks in advance

  • This topic was modified 5 months, 3 weeks ago by  erics44.

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  June 4, 2024 at 3:10 pm

  #4426159

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.