title: SSIS Data Conversion task is giving wrong output when source datatype is BIT
body: <p>I have created two tables from below script:</p>
  <pre><code>CREATE TABLE Test (ISDELETED BIT)
  
  CREATE TABLE Test1 (ISDELETED INT)
  </code></pre>
  <p>Table Test data:</p>
  <p><a href="https://i.stack.imgur.com/lzqrf.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/lzqrf.png" alt="enter image description here" /></a></p>
  <p>Here datatype of column <code>isdeleted</code> in table <code>test</code> is <code>BIT</code> and in table <code>test1</code> datatype is <code>INT</code>. So now using SSIS I am trying to load data from <code>test</code> table into <code>Test1</code> table.</p>
  <ol>
  <li>screenshot of DFD: Source is TEST and Destination is Test1</li>
  </ol>
  <p><a href="https://i.stack.imgur.com/pmNlO.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/pmNlO.png" alt="enter image description here" /></a></p>
  <ol start="2">
  <li><p>Bit to int conversion
  <a href="https://i.stack.imgur.com/FEbFT.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/FEbFT.png" alt="enter image description here" /></a></p>
  </li>
  <li><p>Mapping of converted column with destination
  <a href="https://i.stack.imgur.com/HaD3l.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/HaD3l.png" alt="enter image description here" /></a></p>
  </li>
  </ol>
  <p>After running this package getting below output in Test1 table:</p>
  <p><a href="https://i.stack.imgur.com/x6Bbr.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/x6Bbr.png" alt="enter image description here" /></a></p>
  <p>So as output I am getting data -1 instead of 1.</p>
  <p>I think this is SSIS bug. If anyone has a solution on the above problem then please help.</p>