CODEWITHSUNDEEP
azure-data-factory
Gregory Suvalian
Gregory Suvalian

Reputation: 3832

How do I convert string to datetime in ADF?

I'm transforming Rest data results and sink into Azure SQL and it fails with error below when translating string into DateTime2.

"ErrorCode=UserErrorInvalidDataValue,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Column 'ABOR_CDOM_Seed_Datetime' contains an invalid value '2017-01-02T16:33:43.223Z'. Cannot convert '2017-01-02T16:33:43.223Z' to type 'DateTime' with format 'yyyy-MM-dd HH:mm:ss.fffffff'.,Source=Microsoft.DataTransfer.Common,''Type=System.FormatException,Message=String was not recognized as a valid DateTime.,Source=mscorlib,'"

Upvotes: 4

Views: 12808

Answers (1)

Gregory Suvalian
Gregory Suvalian

Reputation: 3832

One has to go to Schema of sink and add Format as below to accommodate for this custom format

enter image description here

Upvotes: 6

Related Questions