title: Query join with SSIS parameter
body: <p>It is possible to use parameter (SSIS variable) after left join in query in OLE DB Source? The query looks like:</p>
  
  <pre><code>...
  FROM X
  LEFT JOIN ?
  ...
  </code></pre>
  
  <p>where "?" is string variable, which I dynamically changing (based on loop iteration). </p>
  
  <p>When I put this string, except "?" - it works. When I deleted it and parametrized I got:</p>
  
  <blockquote>
    <h2>TITLE: Microsoft Visual Studio</h2>
    
    <p>Parameters cannot be extracted from the SQL command. The provider
    might not help to parse parameter information from the command. In
    that case, use the "SQL command from variable" access mode, in which
    the entire SQL command is stored in a variable.</p>
    
    <p>------------------------------ ADDITIONAL INFORMATION:</p>
    
    <p>Syntax error, permission violation, or other nonspecific error
    (Microsoft SQL Server Native Client 10.0)</p>
    
    <p>------------------------------ BUTTONS:</p>
    
    <h2>OK</h2>
  </blockquote>
  
  <p>I use MS 2008R2.</p>