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 ?
