title: Import Flat File containing multiline fields in SSIS
body: <p>I would like to import a flat file *.csv in SSIS. But one field is a multiline text. I do not have special record delimiter (and there is no way to get one), which is therefore the carriage return \r\n or CRLF.</p>
  
  <p>The problem is : when SSIS meets a CRLF in a multiline field, he passes to the next line instead of continuing as the multiline field.</p>
  
  <p>Here is the header and some first lines :</p>
  
  <pre><code>"name", "firstname", "description", "age"
  "John", "Smith", "blablablablablabla", 25
  "Fred", "Gordon", "blablabla
  blablablabla", 33
  "Bill", "Buffalo", "bllllllllllllaaaaaaa
  blaaaaaaa
  blaalalalaaaaaaaaaa", 44
  </code></pre>
  
  <p>This example above contains 1 header and 3 records. SSIS understands it as 1 header and 6 records and then get errors, of course.</p>
  
  <p>I don't know how can i handle that problem.</p>
  
  <p>Hope you should help me.</p>