Hello Everyone,

I have a excel file that has a variable column header name. Meaning,
one of the column name actually contains some data. So, during the data
transfer, I need to read the column header information in the first row
of the excel file in the Data pump task in the DTS package.

I do know that, to read the data in a particular column (let's say
first column) we can use DTSSource("col1"). But in this case, I need to
read the column header information in the first column.

Thanks.