title: SSIS Conditional Split - multiple conditions
body: <p>I am trying to check if any of the column has changed. I have tried put all in on condition:</p>
  
  <pre><code>Taxes != (ISNULL(LookupTaxes) ? 0 : LookupTaxes) || Checksum != (ISNULL(LookupChecksum) ? 0 : LookupChecksum) || FeeIncome != (ISNULL(LookupFeeIncome) ? 0 : LookupFeeIncome) || CommissionReceived != (ISNULL(LookupCommissionReceived) ? 0 : LookupCommissionReceived) || CommissionPaid != (ISNULL(LookupCommissionPaid) ? 0 : LookupCommissionPaid) || Premium != (ISNULL(LookupPremium) ? 0 : LookupPremium)
  </code></pre>
  
  <p>but this is always returning <code>FALSE</code> although I have manually changed Taxes. If I put each condition separately than it works, for example:</p>
  
  <pre><code>Taxes != (ISNULL(LookupTaxes) ? 0 : LookupTaxes)
  </code></pre>
  
  <p>returns <code>TRUE</code>. If I use 6 conditions (instead of 1) for each column and output results into Union All is this method giving me what I need? My biggest concern is if rows will be duplicated. I have checked and looks like they are not but I wonder why some condition picks X records and another Y when I have changed both columns (related to these two conditions). For example, all Taxes and Premium columns are changed. In Conditional Split output "Taxes have changed" condition picks 1,000,000 rows, "Premium has changed" picks 100 rows. I know that this doesn't make any difference in my case because for me it's important that these rows are picked up for update but I am just confused about how this thing works.</p>