title: SSIS dataflow: SQL Command from Variable, with parameters
body: <p>I defined a variable with the text of a parameterized query like this </p>
  
  <pre><code>select * from t where col = ?
  </code></pre>
  
  <p>Now, I am using that variable <code>@[User::sqltext]</code> in an OLE DB source for a dataflow task.</p>
  
  <p>Problem is I don't see a way to set the parameters as I would have if I had supplied the SQL text in the source directly.</p>
  
  <p>What am I missing?</p>