How to detect more or fewer columns in a CSV, in a Flat File Source SSIS?
<p>I have a problem with a CSV file with open source flat file in an SSIS package.</p>

<p>I set up 10 columns in the file, but I try to detect those lines that have 9 or fewer columns or more than 10 on my own.</p>

<p>If I declare Omit the error, omit the entire line. If I declare Redirect line, not continuous by the red arrow. If I declare Component error, fail to detect a line that contains 10 columns.</p>

<p>Any suggestions?</p>