CODEWITHSUNDEEP
dateazurenullazure-data-factoryazure-blob-storage
Ariox66
Ariox66

Reputation: 660

Null dates being converted to 1900-01-01 in Azure Data Factory

I am bringing data from different databases to Blob storage in Azure by Data Factory, the problem is all the date values turn into 1900-01-01 when Null.

Do you have any suggestion what to do in order to keep the null value?

Thanks

Upvotes: 0

Views: 392

Answers (1)

Venkata Dorisala
Venkata Dorisala

Reputation: 5085

You have to use Custom Activity to achieve this. In your Custom Activity you will have access to the source and destination Linked Services and Datasets. You can transform the data the way you want. You have to write your own transformation logic.

You will not have much control over data transformation if you are using Data Factory's Copy Activity.

Another Approach is to use Data Factory Management APIs. This way you can create output dataset structure as per the input data. In this approach you will have full control over the Data Movement and Transformations.

Upvotes: 1

Related Questions