Removing footer from SSIS Flat File

Question

How do you deal with a flat file footer in SSIS? There is an option to get rid of header row(s) but there does not seem to be an (obvious) way to go about removing the footer. In my situation I actually have to remove 19 lines of footer rows from my flat file.

I have thought about using a script task to achieve this, but it seems like overkill.

What is the best way to remove multiple lines of footer info from the end of a file file in SSIS?

Answer 1

Unfortunately, there is no good way to remove the footer rows besides the script task. I have used the script task to add/remove headers and/or footers before a couple times in some of my packages.