Not null columns in source are being migrated as Null columns in sink side using ADF.

HemaSunder Bugatha 0 Reputation points
2023-04-17T09:10:08.01+00:00

I have few not null columns in SQL Server (Source) which are being migrated as null to Azure SQL Database (Sink). Is it a limitation in ADF that it would migrate the columns as Null by default?

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,691 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Alberto Morillo 32,981 Reputation points MVP
    2023-04-18T03:10:50.41+00:00

    If you Preview the data, make a click on the columns where the issue is happening and click Statistics to make sure those columns do not have null values. If some of the columns are datetime or date columns, the format of the data may be the issue. Try to set those columns as string and if the nulls are not there, then the issue is the format of the data.