title: Why is SSIS Conditional Split including unwanted data regardless of condition?
body: <p>I have the following condition set in <code>SSIS Conditional Split</code> to send all invalid address to the Output Name <code>InvalidOutput</code>.</p>
  
  <p>However, I keep getting some addresses with <code>Null</code> <code>Address1 column</code>. I am not sure why.</p>
  
  <pre><code>ISNULL(LEN(TRIM(Address1)) &gt; 5) || 
  ISNULL(LEN(TRIM(ZipCode)) == 5) || 
  ISNULL(LEN(TRIM(City)) &gt;= 5) || 
  ISNULL(LEN(TRIM(Province)))
  </code></pre>