title: SQL Command text with parameter OLEDB Source
body: <p>I am working with SQL Server Integration Services 2008. In my Data Flow task I got a OLEDB source. I choose SQL command as the Data Access mode and following is my sql text</p>
  
  <pre><code>Select * from table1 where ID=?
  </code></pre>
  
  <p>And from parameters tab my Parameter Name is zero "0" and value is coming from a package level variable.</p>
  
  <p>I tried to replace the parameter name with "Parameter0" but I always get the same error that</p>
  
  <pre><code>Error: "No Value given for one or more required parameters"
  </code></pre>
  
  <p>But there is a value for my variable</p>
  
  <p>Kindly help</p>