title: Using SSIS Parameters in LIKE Query
body: <p>I'm not able to find the right syntax to use a parameter within a LIKE clause in an SSIS SQL Server OLEDB Source component. For a trivial example, consider the following single-column table "tblTeams", listing teams and team members as a single string (it's stupid, I know):</p>
  
  <pre><code>╔═══════════════╗
  ║ TeamMembers   ║
  ╠═══════════════╣
  ║ A - Joe       ║
  ║ A - Melissa   ║
  ║ B - Frank     ║
  ║ C - Angela    ║
  ║ A - Luis      ║
  ║ C - Ashley    ║
  ║ B - Sam       ║
  ╚═══════════════╝
  </code></pre>
  
  <p>I want to run a for loop that exports files of members per team. The loop has an input variable from an array of team names: "A", "B", "C", etc. I'd like to use that variable as a parameter in an OLE DB Source to select the team members as such:</p>
  
  <pre><code>SELECT  [TeamMembers]
  FROM    tblTeams
  WHERE   [TeamMembers] LIKE '?%';  --where ? is param = "A", "B", or "C"
  </code></pre>
  
  <p>However, the syntax here considers the parameter placeholder to be question mark string. Moving the placeholder outside breaks the LIKE clause. Is it possible to use an SSIS parameter in a LIKE?</p>