title: ADF Mapping Data in Sink Table Error - Sink Table remains empty
body: <p>I have a Data flow in Azure Data Factory which I want to use to combine data from three sources and then sink in a destination table (with some transformation in-between). For the sink table I created a table in SQL, matching the column headers and data types from my Data Flow in Azure.</p>
  <p>However when I publish the data flow, the sink table remains empty. The only error I get is under Mapping &quot;At least one incoming column is mapped to a column in the sink dataset schema with a conflicting type, which can cause NULL values or runtime errors.&quot; This seems to be inhibiting me from enabling Auto Mapping - so I mapped the columns manually.</p>
  <p>So where I'm at the moment:</p>
  <p><a href="https://i.stack.imgur.com/jtNKu.png" rel="nofollow noreferrer">DataFlowLayout</a></p>
  <ol>
  <li>I tried manually mapping the columns - the datatypes in my input and my sink tables match up with each other but my sink table is still empty</li>
  </ol>
  <p><a href="https://i.stack.imgur.com/CcHtq.png" rel="nofollow noreferrer">SinkTableDataMapping</a></p>
  <ol start="2">
  <li>Under Data Preview for both my source and my sink tables I am able to view a sample of my data, so they are not empty</li>
  </ol>
  <p><a href="https://i.stack.imgur.com/x8E0v.png" rel="nofollow noreferrer">SinkTableDataPreview</a></p>
  <p>Anyone experience something similar?</p>