title: SSIS Lookup DB and Count results
body: <p>In SSIS 2012, Data Flow, I take in an excel document as my source with 200 rows of records. The excel document has a column "Name". I want to look up a DB and find out how many records have that "Name" for each of the 200 rows. And add this count as an output column.</p>
  
  <p>EG: select count(*) from MyTable where Name = ?</p>
  
  <p>Name   Count</p>
  
  <p>Mark   4</p>
  
  <p>Sam    2</p>
  
  <p>Tim    9</p>
  
  <p>I can't see how to use Aggregate with the parameter.
  Row Count just does a count on all rows.
  I tried a SQL execute task but again, I can't see how to bring in the Name parameter.</p>
  
  <p>I think this is a basic thing to do but I can't find it anywhere on SSIS. Can anyone advise on where I'm going wrong please?</p>