title: SSIS returns Null when query works
body: <pre><code>CASE WHEN o.ORDER_TYPE_ID = '0-JFE3' OR 
  (o.ORDER_TYPE_ID = '1-55T3' AND 
  po.ORDER_TYPE_ID = '0-JFE3') Then 'Y'
      Else 'N'
      End as Extranet_Order
  </code></pre>
  
  <p>Above is the code that returns <code>Y</code> and <code>N</code> in preview but the value becomes  <code>Null</code> in <code>DT_STR</code> to <code>CHAR(1) null</code> column.</p>
  
  <p>Can you see what's wrong?</p>