Hello,
I am new to Azure Synapse Analytics. I have an XLS file containing data and I want to upsert that data into an Azure Synapse dedicated SQL table.
I have created a stored procedure to upsert the data into the table.
I have used a lookup activity to load the XLS file and pass the JSON data to the stored procedure via a stored procedure activity.
It is working for inserting the data, but while updating, it is giving me the following error:
{
"errorCode": "2402",
"message": "Execution failed against SQL Server. Please contact the SQL Server team if you need further support. SQL error number: 468. Error Message: Cannot resolve the collation conflict between \"SQL_Latin1_General_CP1_CI_AS\" and \"Latin1_General_BIN2\" in the equal to operation.",
"failureType": "UserError",
"target": "Stored procedure for Insert Email",
"details": []
}
