Thanks for your reply. I am trying to import a flat file into an SQL Server table.
The file structure is as follows:
I am only interested in importing the first row. On a daily basis i may have multiple files, but the only row I am interested in importing is the top row.