If you know the data in a column that identifies the row as a header, then you can use skip row.
However, you have to sepcify all DTSSource and DTSDestination details in the same script:
If DTSSource("Col001") = "HEADERTEXT" Then
Main = DTSTransformStat_SkipRow
DTSDestination("Col001") = DTSSource("Col001")
DTSDestination("Col002") = DTSSource("Col002")
Main = DTSTransformStat_OK
Not very nice and it does mean that each row is procesed one at a time, so it will be slow as well.
If the files are large and processing is to be kept at a minimum, then you will have to try something more complicated.
Many ways of doing this:
a)Open the excel file and count the number of rows using excel object. Put this into global variable and set as the last row to be imported.
b) Open ecel using excel object and delete row 2, then sabe it again before importing.
The Users are always right - when I'm not wrong!