title: Record only certain rows of a text file in SSIS
body: <p>I'm having a hard time trying to do a simple loading of data from a flat file to a database.
  The problem is that there are bad rows or at least rows that are not formatted as data in that text file.</p>
  
  <p>Sample.txt:</p>
  
  <pre><code>                Stackoverflow School at Philippines
  
  Record: 100101
  Date: 6/20/2014
  
  Name:                Age: About:
  -------------------- ---  --------------------------
  Coolai               19   Bad Row Question
  Qwerty               17   Java
  Qwerty               19   C#
  *User1               21   Dynamic Data
  User4                27   Assembly
  
                      Stackoverflow School at Nippon
  
  Record: 100102
  Date: 6/23/2014
  
  Name:                Age: About:
  -------------------- ---  --------------------------
  Sayuri               19   MSSQL
  Niwatori             21   Dynamic Data
  Jagaimo              27   Assembly
  *User7               21   Dynamic Data
  User9                27   Assembly
  </code></pre>
  
  <p>I am using Fixed Width format on the Flat File Connection and tried to approach the problem using conditional split but once it hits the white space, it stops loading the data.</p>
  
  <p>Is it possible to load the data depending on a certain row count? Because at the end, this is the only thing I want from the text file:</p>
  
  <pre><code>Coolai               19   Bad Row Question
  Qwerty               17   Java
  Qwerty               19   C#
  User1                21   Dynamic Data
  User4                27   Assembly
  Sayuri               19   MSSQL
  Niwatori             21   Dynamic Data
  Jagaimo              27   Assembly
  User7                21   Dynamic Data
  User9                27   Assembly
  </code></pre>
  
  <p>Sample.txt file <a href="https://drive.google.com/file/d/0B8Y86zrZbhvdTWFpSnB6MkFWeEU/" rel="nofollow">LINK</a>.</p>