title: SSIS Lookup transformation not finding matches
body: <p>I have a Lookup transformation that does not seem to be finding obvious matches.  I have an input file that has 43 records that includes the same CustomerID which is set as an 8 byte-Signed Integer.  I am using the Lookup to see if the CustomerID already exist in my destination table.  In the destination table the CustomerID is defined as BigInt.  </p>
  
  <p>For testing, I truncated the Lookup(destination) table.  I have tried all three Cache settings with the same results.</p>
  
  <p>When I run the SSIS package, all 43 records are sent through the No Match Output side.  I would think that only the 1st record should go that direction and all others would be considered as a match since they have the same CustomerID.  Additionally, if I run the job a second time(without truncating the destination) then they are all flagged as Matched.</p>
  
  <p>It seems as if the cache is not being looked at in the Lookup.  Ultimately I want the NO Match records to be written to the Destination table and the Matched records to have further processing.</p>
  
  <p>Any ideas?</p>