title: Detecting partial rows in SSIS
body: <p><strong>Situation:</strong> A tab delimited row from a flat file source is missing columns at the end of the row. The rows are delimited by <code>{CR}{LF}</code> in the Flat File Connection Manager, and the last column is delimited by <code>{CR}{LF}</code> as well. All other columns are delimited by <code>Tab {t}</code>. SSIS is importing the row.</p>
  
  <p>Example:</p>
  
  <p>Column_1<code>{t}</code>  Column_2<code>{t}</code>   Column_3<code>{t}</code>   Column_4<code>{CR}{LF}</code></p>
  
  <p>123<code>{t}</code>   123<code>{t}</code>    123<code>{t}</code>        123<code>{CR}{LF}</code></p>
  
  <p>123<code>{t}</code>   123<code>{CR}{LF}</code></p>
  
  <p>123<code>{t}</code>   123<code>{t}</code>    123{<code>{t}</code>   123<code>{CR}{LF}</code></p>
  
  <p>123<code>{t}</code>   123<code>{t}</code>    <code>{t}</code>   <code>{CR}{LF}</code></p>
  
  <p>123<code>{t}</code>   123<code>{t}</code>    123<code>{t}</code>    123<code>{CR}{LF}</code></p>
  
  <p><strong>Problem:</strong>  A partial row that does not have the remaining columns tab delimited (see row 2 above) treats the following row as a part of the current row, while a row containing the tab delimited columns that are blank (see row 4 above) does not.</p>
  
  <p><strong>Desired Output:</strong> An error is desired to signal a partial row.</p>
  
  <p>What is the best method to check for partial rows in the middle of a file?</p>