title: SSIS error: delimiter for column "columnX" is not found
body: <p>This question was asked here before but the solutions proposed don't seem to be working for me.</p>
  
  <p>I'm trying to import a text file pipe delimited text qualifier <code>"</code>. The SSIS package is returning the error message </p>
  
  <blockquote>
    <p>delimiter for column "columnX" is not found</p>
  </blockquote>
  
  <p>where column X is the last field in the file.</p>
  
  <p>In the connection manager advanced tab, I have set up the column delimiter for <code>columnX</code> to <code>{LF}</code> while all the other fields are set to vertical <code>|</code>.</p>
  
  <p>I have verified the file and there are no missing fields. There are some null values but all the fields are there.</p>
  
  <p>I can't point out what is causing this. Your help would be greatly appreciated.</p>