title: How do I convert string to datetime in ADF?
body: <p>I'm transforming Rest data results and sink into Azure SQL and it fails with error below when translating string into DateTime2. </p>
  
  <blockquote>
    <p>"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,'"</p>
  </blockquote>