my starting point would be to look at a script task using C#. I have done similar with flat files but not to Excel. But you should be able to access the sheets in the Excel using C# and then look at the first row.
googling 'c# read sheets from excel' came up with
HTH
E
😀