I would like to import a text file (see attached).
The text file has some information above the header rows, and the header rows and values do not start until several rows down.
I can import data easily if the file was structured purely in terms of header rows and the values but not so easily with the file attached.
I want to basically import the date and time into one table and then import the actual header row along with the values below it into another table.
I would be grateful if somebody had an idea of how to go about this manually so I can incorporate it into an SSIS package I'm trying to build.