How to change source data type string to datetime in ADF pipeline

Lilly W 130

How do I change a string data type in a blob file to a datetime to map it to a datetime column to the SQL database sink in a Copy Data task in an ADF pipeline?

Nandan Hegde 29,886 Reputation points MVP

2023-02-05T14:09:24.2333333+00:00

Hey,

Please try opening the JSON file and update the type from there and publish it
Lilly W 130 Reputation points

2023-02-05T14:58:43.8133333+00:00

It's a csv file. Otherwise, how do you access the edit option in your screenshot?
Lilly W 130 Reputation points

2023-02-05T17:49:54.1833333+00:00

Thank you!
KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee

2023-02-09T08:36:19.3533333+00:00

Hi Lilly W,

Just checking in to see if the suggestion provided by Nandan Hegde was helpful. If it answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread.

And, if you have any further query do let us know.

Thank you

Accepted answer

Nandan Hegde 29,886 Reputation points MVP

2023-02-06T04:21:10.52+00:00

Hey, Sorry for any confusion. I meant the JSON code of the ADF pipeline :

There would be mappings and data types between Source and sink :

Update the type for the required column
Please sign in to rate this answer.

2 people found this answer helpful.
Lilly W 130 Reputation points

2023-02-18T00:16:15.9866667+00:00

posted response in wrong section
Sign in to comment

How to change source data type string to datetime in ADF pipeline

0 additional answers