Hi, I have data source like "2019-03-13 00:00:00.0000000 +07:00" with DATETIMEOFFSET as datatype and I have defined the Date Pattern at all relevant places as "yyyy-MM-dd HH:mm:ss.SSSSSSS XXX" and the output DBTYPE as DATETIMEOFFSET. But whenever I run the job the result destination is like "2019-03-12 17:00:00.0000000 +00:00" for datetimeoffset field has timezone defaulted to +00:00 rather the current data (+07:00 in my case) or on tLogRow look like "2019-02-13 17:00:00.0000000 Z". Can you guys help me to solve this issue to make destination datetimeoffset data same result as source data?
thankyou
