title: Transforming data type in Azure Data Factory
body: <p>I have a "Copy" step in my Azure Data Factory pipeline which copies data from CSV file to MSSQL.</p>
  
  <p>Unfortunately, all columns in CSV comes as <code>String</code> data type. How can I change these data types to match the data type in SQL table.</p>
  
  <p><a href="https://i.stack.imgur.com/XywgU.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/XywgU.png" alt="enter image description here"></a></p>
  
  <p>Here is how the data is available in CSV file.</p>
  
  <p><a href="https://i.stack.imgur.com/IUDIS.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/IUDIS.png" alt="enter image description here"></a></p>
  
  <p>I would like to change data type of <code>WIPStateKey</code> to <code>Integer</code> and <code>ReportDt</code> to <code>Timestamp</code>. I do not seem to find an option to achieve this.</p>