title: Azure Data Factory: Wrong and unexpected Datatype conversion during import from csv to sql server via pipeline
body: <p>I am trying to load data from a csv to a sql server database using an Azure pipeline copy data operator. During the import data is converted to other types.</p>
  
  <p>in the Source preview in the pipeline I see the following</p>
  
  <p>1- the value "0044" is converted to 44</p>
  
  <p>2- the value 2020000000000000 is converted to 2E+16</p>
  
  <p>3- the value 5.2 is converted to February 5th</p>
  
  <p>4- the value 9.78 is converted to September 1978</p>
  
  <p>so far i could not find a solution for 0044,</p>
  
  <p>I the other cases here is what I did:</p>
  
  <p>for 2 I enclosed the number 2020000000000000 in "" then it worked, though for some reason I get it enclosed in four " like so: ""2020000000000000""
  for 3 and 4 I replaced the dot for a comma and then it worked.</p>
  
  <p>But I would like to be able to tell the import utility to treat everything just as string and do the conversions in the database.</p>
  
  <p>how can I achive this?</p>
  
  <p>the code shows following for one of the columns in 3 and 4:</p>
  
  <p>(</p>
  
  <pre><code>       "source":(
  
                "name": "Amount"
  
                "type": "String"
  
         )
  
         "sink":(
  
                "name": "Amount"
  
                "type": "String"
  
         )
  </code></pre>
  
  <p>)</p>
  
  <p>Best Regards,</p>