title: Using SSIS to query ADO .NET source query passing in parameters from SQL Server
body: <p>I would like to pass parameters to a MySQL query using ado.net as the source of the query.</p>
  
  <pre><code>SELECT *  
  FROM   userinfo
  WHERE  load_date &gt; '2012-01-07' 
  AND    load_date &lt; '2012-01-14'
  </code></pre>
  
  <p>I have a settings table in sql server that has my values:</p>
  
  <pre><code>SELECT  startdate, enddate 
  FROM   tblsetting
  </code></pre>
  
  <p>I have managed to pass these values into SSIS. If I run a query against my sql server tables I am able to use this: </p>
  
  <pre><code>SELECT *  
  FROM    userinfo
  WHERE   load_date &gt; ? 
  AND     load_date &lt; ?
  </code></pre>
  
  <p>But when I change my source to ado.net, connecting to mysql server , it does not like that syntax. Can anyone explain what am I missing?</p>