Forum Discussion
How to handle null values in Data Factory
Hi, I created a pipeline in Azure Data Factory that grabs data from a REST API and inserts into an Azure table. The pipeline looks like the following: The pipeline failed with the following e...
I'm facing a similar problem that I'm trying to find an answer to. In my case, I have Access as a sink with a self-hosted integration runtime (yes, I know Access is very legacy, but it's a client requirement). The data types all line up between the SQL view source and the Access database sink, but it seems that requardless of whether I map or don't map the column's, if there's a null date value in the first row, ADF (or the self-hosted integration runtime?) insists on picking an erroneous data conversion. This results in an error the first time a non-null date occurs in a column where the first row had a null value.