Read portion of file using SSIS

Is it possible to read a portion of a file using SSIS. The file format is:

date: 17 Apr 07

input file: input1.unl

output file: output.unl

table1-column1 table1-column2 ..................

123 23445

235 33367

table2-column1 table2-column2 ......................

234 454

444 89877

i have to read only the table1. i have written a routine in c# that reads only table1 but that is too slow. Is there any efficient solution?

It looks like your table1 and table2 have the same format. Is that correct?

Do your rows have some identifier that tells from which table they are coming? If yes, you might be able to load everything and then filter out the rows you need.

HTH.

|||No the tables have different format. Rows have no identifier but there are two line breaks between the two tables. Can I read only that portion of file.|||

No, the flat file parser will not be able to do that.

You might be able to use the Script Task to break your files before they are used by Flat File source.