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


