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(80, 55.00000000000001%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
I was trying to copy data from CSV to Sql table in Data Factory. The data contains date time column. I tried using copy activity but there are some null values in date time column, I am getting an error like invalid conversion from string to date time. Please help me to resolve it.
An Azure service for ingesting, preparing, and transforming data at scale.
Answer accepted by question author
is it null value or blank value in your csv? If it is null (not in quotes) or just empty (again with out quotes), it must work. Can you check this?
If it is not resolved, paste a sample data that causes the error.
Hi, Thank you for the reply. It is blank value (with quotes, "")
from CSV, can you remove the quotes and try.