title: SSIS read flat file skip first row
body: <p>First of all, I did spend quite some time on research, and I know there are many related questions, though I can't find the right answer on this question.</p>
  
  <p>I'm creating a SSIS package, which does the following:
  1. Download and store CSV file locally, using HTTP connection.
  And 2. Read in CSV file and store on SQL Server.</p>
  
  <p>Due to the structure of my flat file, the flat file connection keeps giving me errors, both in SSIS as in the SQL Import Wizard.</p>
  
  <p>The structure of the file is:</p>
  
  <pre><code>"name of file"
  "columnA","columnB"
  "valueA1","valueB1"
  "valueA2","valueB2"
  </code></pre>
  
  <p>Hence the row denominator is end of line {CR}{LF} and the column denominator is a comma{,}, with text qualifier ".</p>
  
  <p>I want to import only the values, not the name of the file or the column names.</p>
  
  <p>I played around with the settings and got the right preview with the following settings (see image below)</p>
  
  <p><a href="https://i.stack.imgur.com/dvPGD.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/dvPGD.png" alt="enter image description here"></a></p>
  
  <pre><code>- Header rows to skip: 0
  - Column names in the first data row: no
  - 2 self-configured columns (string with columnWidth = 255)
  - Data rows to skip: 2
  </code></pre>
  
  <p>When I run the SSIS Package or SQL Import Wizard I get the following error:</p>
  
  <blockquote>
    <p>[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.  The
    PrimeOutput method on Flat File Source returned error code 0xC0202091.
    The component returned a failure code when the pipeline engine called
    PrimeOutput(). The meaning of the failure code is defined by the
    component, but the error is fatal and the pipeline stopped executing. 
    There may be error messages posted before this with more information
    about the failure.</p>
  </blockquote>
  
  <p>I can't figure out what goes wrong and what I can do to make this import work.</p>