Forum Discussion

SNikita's avatar
SNikita
Copper Contributor
Nov 21, 2023

Data Factory : Load source datetime into string field without conversion

Hi, I'm currently trying to load a datetime field with time zone sourced from SOAP XML response into a SQL Server target table but want to ignore the time zone from source.

Source : 2023-10-17T09:00:00+02:00

Expected in target : 2023-10-17T09:00:00

 

If the target column is defined as datetime, the data factory copy activity converts it to local time zone and data captured is 2023-10-17T07:00:00.

If target column is defined as varchar or nvarchar, the copy activity loads the data as 2023-10-17 07:00:00 AM.

 

Can you please suggest how to source the datetime field without data factory converting it into local time zone ? 

 

No RepliesBe the first to reply

Resources