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

Question

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

Answer 1

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.

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

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

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.