Easiest path is probably to switch the file connector to see a single column. Use a Script component and specify it as a transform. The code is very straightforward and there are tons of examples on-line.

I'm interested in your statement that you want some information from the header. That will mean treating it like a data row. The Script task will again help, since you can tell you are on the first record. You might also want to send the header record to a separate output, unless you really want it loaded in the database.

Let me know if you have any difficulties or questions.