azure data factory: copy step json to sql database wrong date

Question

I´m using the azure data factory copy activity within a pipeline to get json input into azure sql database table. All date fields contains a +1 within the timestamp (e.g. 2018-10-01T00:00:00+01:00) in the json source. After mapping to date field in database i see 2018-09-30, hence one day before as in the source.

I do not want to use data flow and convert to string, substring and convert back to date.

Is there any other more elegant approach to get this fixed?

Thx a lot in advance

Answer 1

Hi @Müller, André ,

Thank you for posting query in Microsoft Q&A Platform.

As I understand the ask here, You are looking ways to take your source date filed and perform some transformations on top it. Please correct me if am wrong.

In copy activity there is a way to define source string date format while loading to string. Check link where same explained with screenshots.
https://learn.microsoft.com/en-us/answers/questions/439579/does-adf-copy-acitivity-allow-to-format-date-using.html

But, in Copy activity there is no way to transform dates. hence we should go with data flows only.

There is no direct work arounds in ADF to do these kind of transformations without Data flows.

I hope above answer helps. Please let us know if any further queries.

---

Please consider hitting Accept Answer. Accepted answers helps community as well.