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

Question

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 36,716 Reputation points MVP Volunteer Moderator

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,737 Reputation points Microsoft Employee Moderator

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

Answer accepted by question author

0 additional answers

Your answer

Nandan Hegde 36,716 Reputation points MVP Volunteer Moderator

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,737 Reputation points Microsoft Employee Moderator

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

Answer 1

Nandan Hegde 36,716 MVP Volunteer Moderator

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

User's image

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

User's image

Update the type for the required column

Lilly W 130 Reputation points

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

posted response in wrong section

Share via

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

0 additional answers

Your answer