Hi @Kellwyn Edwin ,
Welcome to Microsoft Q&A forum and thanks for reaching out here.
After having a look at the error message, it suggests that there was a failure in the upsert operation on the target table. The cause of the error is that the column "columnx" does not allow null values, but a null value was attempted to be inserted into the column.
You can check the mapping in the activity to make sure that the source column is mapped to the correct sink column and that the source column has a value. You can also modify the source data to ensure that the column has a value (may you can use iifNull() function to manually change the specific column from null to empty string value.) before attempting the upsert operation.
You may also try exploring below error row handling mechanism and implement in your data flow settings to overcome the problem:
Ref doc: Error row handling
In additional you can also use conditional splitting of rows with null values from the rows without null values in any of the source columns and then fix the null values with valid values ( iifNull() function to manually change the specific column from null to empty string value.) and do upsert to the destination:
Ref doc: Check for NULLs in all columns
Hope this info helps. Let us know how it goes.
Please don’t forget to
Accept Answer and
Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.
@Kellwyn Edwin We still have not heard back from you. Just wanted to check if the below information was helpful? If it answers your query, please do click
Yesfor "was this answer helpful", as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.