any suggestions on dealing with a flat file in the format below. I only want to process the data columns in the middle of the file and want to ignore all other rows. This was a very simple task in DTS with a small amount of VBScript in the transformation but it doesn't seem as straightforward in SSIS. thanks
......... file example ......
start-of-file
header1
header2
...
start-of-data
col0|col1|col2|col3|....
col0|col1|col2|col3|....
col0|col1|col2|col3|....
end-of-data
end-of-file