title: SSIS Package Lookup not working
body: <p>I've a SSIS package where I would like to validate the <code>productCode</code> by making sure that it exists on destination database.</p>
  
  <p>The way I've done is setup the Lookup Transformation and mapped source <code>productCode</code> with destination <code>productCode</code>. The destination <code>productCode</code> is retrieved by simple sql query.</p>
  
  <p>However, every time I run the package the data doesn't get matched even though all <code>productcode</code> on csv file exists on destination table.</p>
  
  <p>Am I using Lookup for wrong purpose? </p>
  
  <p>The back end is Oracle DB. Also noticed that Lookup Component has exclamation mark with "Cannot retrieve the column page info from OLEDB provider".</p>
  
  <p>Thanks.</p>