title: Azure Data Factory Unable to convert string column value to Datetime
body: <p>I am using a existing ADF pipeline to copy data from a blob to sql. My source data has a column value like '20000101'. I am getting error when ADF try to convert this to dateTime format from string. I am using json translators like &quot;dateTimeFormat&quot;: &quot;yyyy-MM-dd HH:mm:ss.fff&quot;. But still end up getting error as &quot;Exception occured when converting the value '20000101' cannot convert string to datetime type.</p>
  <p>Any suggession?</p>
  <p>Note: I have to handle this only through json mapping. Cannot edit the existing pipeline. Any possibilities here?</p>