title: Parameterized OLEDB source query
body: <p>I am creating an ETL in SSIS in which I which I want my data source to be a restricted query, like <code>select * from table_name where id='Variable'</code>. This variable is what I defined as User created variable.</p>
  
  <p>I do not understand how I can have my source query interact with the SSIS scoped Variable.</p>
  
  <p>The only present options are</p>
  
  <ul>
  <li>Table</li>
  <li>Table from variable</li>
  <li>SQL Command</li>
  <li>SQL command from a variable</li>
  </ul>
  
  <p>What I want is to have a SQL statement having a variable as parameter</p>