title: SSIS Conditional Split NULL
body: <p>I need to detect whether either of two values are null, and if not, whether they differ.</p>
  
  <p>The condition I have in my split is </p>
  
  <pre><code>(ISNULL(ModuleLevelId) &amp;&amp; !ISNULL(LEV_CODE)) || 
  (!ISNULL(ModuleLevelId) &amp;&amp; ISNULL(LEV_CODE)) || (ISNULL(LEV_CODE) ? 0 - ModuleLevelId : (DT_I4)LEV_CODE) != ModuleLevelId
  </code></pre>
  
  <p>but I am told that my expression leads to null, i.e. a non-Boolean condition.</p>
  
  <p>Can anyone help me write the condition that will work please?</p>
  
  <p>Many thanks</p>
  
  <p>Patrick</p>