I would read the head as it were data and concatenate the values in a script component.

One question though: why do you need to fiddle around with the header when you are importing to a SQL Server table?