locked
Mapping Data Flow sink issue - collation RRS feed

  • Question

  • Hello,

    In the data flow, I have a source & sink to same Azure SQL table. The data flow just derives some extra data. The key field in the table has collation and Latin1_General_CS_AS as the values it stores have both upper and lower case characters. But data flow keeps failing with following error:

    {"message":"at Sink 'sink1': java.sql.BatchUpdateException: Cannot resolve the collation conflict between \"SQL_Latin1_General_CP1_CI_AS\" and \"Latin1_General_CS_AS\" in the equal to operation.. Details:at Sink 'sink1': java.sql.BatchUpdateException: Cannot resolve the collation conflict between \"SQL_Latin1_General_CP1_CI_AS\" and \"Latin1_General_CS_AS\" in the equal to operation.","failureType":"UserError","target":"testTP","errorCode":"DFExecutorUserError"}

    Is there a way to stop it failing?


    Wednesday, May 20, 2020 6:29 PM

All replies