title: ssis Merge Join Transformation left outer join where col is null
body: <p>just want to ask about Merge Join Transformation left outer where where Supplier.SupplierCode is null join I have 2 data source  I have this sql script to make it SSIS </p>
  
  <pre><code>SELECT Supplier.SupplierCode, Supplier.SupplierName, Supplier.Address, af.SupplierId, af.SupplierCode AS Expr4, af.SupplierName AS Expr5, af.Address AS Expr6, af.EffectiveDate, af.ExpirationDate, af.CurrentFlag,
  af.Expr1, af.Expr2, af.Expr3
  FROM Supplier LEFT OUTER JOIN
  (SELECT DimSupplier.SupplierId, DimSupplier.SupplierCode, DimSupplier.SupplierName, DimSupplier.Address, DimSupplier.EffectiveDate, DimSupplier.ExpirationDate, DimSupplier.CurrentFlag,
  Supplier.SupplierCode AS Expr1, Supplier.SupplierName AS Expr2, Supplier.Address AS Expr3
  FROM DimSupplier LEFT OUTER JOIN
  Supplier ON DimSupplier.SupplierCode = Supplier.SupplierCode) AS af ON Supplier.SupplierCode = af.SupplierCode
  where Supplier.SupplierCode is null
  </code></pre>
  
  <p>first I take sup script and make it into data OLE DB Source  Command and  use  Merge Join as Transformation left outer to join the to data stream. just want to ask how can I implement where Supplier.SupplierCode is null in ssis and whate is mean </p>
  
  <blockquote>
    <p>Specify whether the transformation handles null values as equal to
    other nulls. NOTE: If null values are not treated as equal values, the
    transformation handles null values like the SQL Server Database Engine
    does.</p>
  </blockquote>
  
  <p>is it same as where Supplier.SupplierCode is null ?
  update what I am trying to remove the null value to insert it to my destination table and remove the delicate  </p>
  
  <p><img src="https://i.stack.imgur.com/xKvP9.png" alt="enter image description here">
  <img src="https://i.stack.imgur.com/DENbD.png" alt="enter image description here"></p>