title: Oracle 12c Number field mapped to DT_WSTR in SSIS
body: <p>I am trying to extract the data from Oracle 12c database table to flat file using Microsoft SSIS 2008.</p>
  <p><strong>Table in Oracle Database</strong></p>
  <pre><code>Create Table Test
  (
    Col1 Varchar2(10),
    Col2 NUMBER default 0
  )
  </code></pre>
  <p>There is no precision / scale is specified for the Col2 Number field. So it is storing the values as given.</p>
  <p><strong>Sample values</strong></p>
  <p><a href="https://i.stack.imgur.com/PGEp2.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/PGEp2.png" alt="enter image description here" /></a></p>
  <p><strong>SSIS Package:</strong></p>
  <p>In SSIS package in OLEDB source component, we mapped the table and Col2 is mapped with DT_WSTR. And if i am changing to DT_Numeric, i am not sure on what to specify in the precision and scale. Since there is no precision / scale mentioned in Oracle table.</p>
  <p><strong>EDIT :</strong></p>
  <p>I am getting the error in OLE DB Source itself in the &quot;Execute Phase&quot; itself,
  [OLE DB Source <a href="https://i.stack.imgur.com/PGEp2.png" rel="nofollow noreferrer">1</a>] Error: There was an error with output column &quot;COL2&quot; (20) on output &quot;OLE DB Source Output&quot; (11).
  The column status returned was: &quot;Text was truncated or one or more characters had no match in the target code page.&quot;.</p>
  <p><a href="https://i.stack.imgur.com/8pZPH.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/8pZPH.png" alt="enter image description here" /></a></p>
  <p>If i modify the data type in Output Columns of OLE DB Source like below, it is working, I have not modified in External Columns and OLE DB Error Output columns. In both the places it is DT_WSTR. Is this is ok?</p>
  <p>And also i have not touched anything in Flat File Destination since i am getting exception in OLE DB Source.</p>
  <p><a href="https://i.stack.imgur.com/KuNQ5.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/KuNQ5.png" alt="enter image description here" /></a></p>