This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](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(144, 16%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHB%3C/text%3E%3C/svg%3E)
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?
![](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(86.4, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Hello HemaSunder Bugatha Welcome to the MS Q&A platform. Are you using copy activity here? Are you migrating data from on-prem SQL server to Azure SQL DB as sink? Can you give me the source SQL server table schema and some sample records so I can try to reproduce the issue and get back to you? Please remove any PPI data and send the details.
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.
Thanks Alberto Morillo Hello HemaSunder Bugatha, I am just checking to see if you got a chance to look into the above answer provided by Alberto.
If this answers your question, please consider accepting the answer by hitting the Accept answer and up-vote as it helps the community look for answers to similar questions.