title: Excel Source failing the pre-execute phase and returned error code 0xC0207013, expecting parameters
body: <pre><code>SELECT UCase(LTRIM(RTRIM(c.F2))) AS Name,c.F2 AS NameProperCase,c.F3 As Initials, c.F4 As CountryCode
  FROM  `Country$` c
  </code></pre>
  
  <p>I have the above query in an SSIS Excel Source as its SQL command. In the Excel Source Editor, i can successfully click preview and see the sample data returned by the query from the Excel file. </p>
  
  <p>I have configured my Excel Connection Manager that the <strong>First row DOES NOT have column headers.</strong> </p>
  
  <p>When i try to execute my package, it fails at this Excel source and the errors below are logged to my text Log file.</p>
  
  <blockquote>
    <p>The SQL command requires 3 parameters, but the parameter mapping only has 0 parameters.</p>
    
    <p>The SQL command requires 3 parameters, but the parameter mapping only
    has 0 parameters.</p>
    
    <p>The SQL command requires 3 parameters, but the parameter mapping only
    has 0 parameters.</p>
    
    <p>"Excel Source 2" (2303) failed the pre-execute phase and returned
    error code 0xC0207013.</p>
    
    <p>"Excel Source 2" (2303) failed the pre-execute phase and returned
    error code 0xC0207013.</p>
    
    <p>"Excel Source 2" (2303) failed the pre-execute phase and returned
    error code 0xC0207013.</p>
  </blockquote>
  
  <p>If i reconfigure the Excel Connection Manager that the <strong>First row HAS column names</strong>, and then replace the Excel source query with the one below, the package runs fine with out errors</p>
  
  <pre><code>SELECT UCase(LTRIM(RTRIM(c.Name))) AS Name,c.Name AS NameProperCase,c.Initials, c.CountryCode
  FROM  `Country$` c
  </code></pre>
  
  <p>I don't have any parameters in the query but i am getting "The SQL command requires 3 parameters, but the parameter mapping only has 0 parameters." in the log file.</p>
  
  <p>The only difference between the failing and succeeding Excel sources is the setting that  First row has column names (Success with out error),  AND First row does NOT have column names (Fails with errors posted above)           </p>