SqlColumnNameNotExist

Question

Hi Data Factory team,

While working on "COPY DATA TO SQL" I am facing the issue like:

Error code: SqlColumnNameNotExist

Failure type: User configuration issue

Details: Failure happened on the 'Sink' side. ErrorCode=SqlColumnNameNotExist,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Column 'reported_data' does not exist in the target table '[covid_reporting].[cases_and_deaths]'.,Source=Microsoft.DataTransfer.Connectors.MSSQL,'

I have uploaded the resources file into the Azure SQL server and created the tables in the database. In the "covid_reporting.cases_and_deaths" the column name is mentioned correctly. Here is the screenshot below.

Don't know why the pipeline is not debugging.

Answer 1

Hi @Bheemaraju Vinay Kumar

Thank you for posting your query!

The error SqlColumnNameNotExist occurs because the column reported_data does not exist in the target table covid_reporting.cases_and_deaths. Based on your table schema, the correct column name is reported_date.

Steps to Resolve:

Verify Column Mapping in ADF - Open the Copy Data activity. Navigate to the Mapping tab. Ensure the source column is mapped to reported_date, not reported_data.

Check Source Data - Ensure the source dataset contains a column named reported_date. If the source column is incorrectly named reported_data, consider renaming or transforming it before copying.

Validate SQL Table Schema - Run the following query in Azure SQL to confirm the correct column name:

SELECT COLUMN_NAME 
FROM INFORMATION_SCHEMA.COLUMNS 
WHERE TABLE_SCHEMA = 'covid_reporting' 
  AND TABLE_NAME = 'cases_and_deaths';

Refresh the Sink Dataset Schema in ADF - Open ds_sql_cases_and_deaths (your sink dataset). Click "Preview Schema" to refresh the structure. Manually update the column mapping if needed.

Republish & Rerun the Pipeline - After updating the mapping, publish your changes and rerun the pipeline.

By addressing these areas, you can resolve the SqlColumnNameNotExist error and ensure seamless data ingestion into SQL.

I hope this information helps. Please do let us know if you have any further queries.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 2

The column name in sink is reported_date whereas the error is for column : reported_data
Check the mapping in the copy data activity