Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
Copy Activity Error - (ADF)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 3%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPD%3C/text%3E%3C/svg%3E)
Puneet-D
1
Reputation point
I have a copy activity which is getting data from a OnPrem SQL Server to Azure Synapse and fails with the following Error "COPY statement failed because non nullable column 'City' cannot have the NULL value as its default". It fails when it starts writing from Blob to Synapse.
]1
The Source & Target columns are defined as NOT NULL and I checked there are no rows with Null values in it or has any default defined as Null on it. Can anyone please help or give some insights what to do?
Thank you,
Puneet
Azure Data Factory
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 52%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMW%3C/text%3E%3C/svg%3E)
Maatoug wassim 76 Reputation points2022-12-14T14:38:46.927+00:00 Hi @Puneet-D ,
Does the source contain a column called 'City' ? -
Puneet-D 1 Reputation point
2022-12-14T15:49:57.01+00:00 Yes it has City column. Thanks!
-
Maatoug wassim 76 Reputation points
2022-12-14T16:09:38.337+00:00 And I suppose mapping is OK so that columns from source goes to the matching destination columns, right ?
-
Puneet-D 1 Reputation point
2022-12-14T16:20:00.487+00:00 Offcourse it goes from source to destination and the mapping is fine. Issue is when source has no Null values why is it getting errored out for NULL value.
Sign in to comment
Sign in to answer