Dynamic Copy Data Auto column map fails because of case sensitivity issue in Source and Sink ColumnName - Azure Data Factory

Reddy, Haripriya 6 Reputation points
2021-06-22T17:32:37.127+00:00

Dynamic Copy Data Auto column map fails because of case sensitivity issue in Source and Sink ColumnName - Azure Data Factory

In Source the column is defined as CITYID and in Sink it is CityID. Due to other Pipelines and transformations I cannot alter the table Column names.

Getting the below error:

ErrorCode=UserErrorInvalidColumnMappingColumnNotFound,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Column name 'CityID' cannot be found in either source data or column mapping.,Source=Microsoft.DataTransfer.ServiceLibrary,'

How can we handle this issue without altering the table at the source or sink

Any resolution approach is appreciated, Thanks

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,490 questions
{count} votes

1 answer

Sort by: Most helpful
  1. PRADEEPCHEEKATLA-MSFT 76,666 Reputation points Microsoft Employee
    2021-06-23T06:52:28.953+00:00

    Hello @Reddy, Haripriya ,

    Thanks for the question and using MS Q&A platform.

    Are you doing explicit mapping (Import Schemas in Mapping section of Copy) or auto mapping from source to sink? If you are doing auto mapping, could you please try explicit mapping by clicking import schemas in Mapping section of your copy activity.

    108473-image.png

    You will experiencing this error message when you pass mapping without Import Schemas:

    108455-adf-clmmappingwithoutimport.gif

    You are able to resolve this error message when you pass mapping with Import Schemas:

    108456-adf-clmmappingwithimport.gif

    Hope this helps. Do let us know if you any further queries.

    ---------------------------------------------------------------------------

    Please "Accept the answer" if the information helped you. This will help us and others in the community as well.