inserting excel data into SQL Server using SSIS

I'm trying to insert excel data using Data flow task, Excel source to OLE DB Destination, my col names in the Excel file are in the following order

EmpId Empname Dept Sal StartDate EndDate EmpType

My question is do I need to define them in the same order as they are in the excel sheet or for e.g what if they are in the following order where StartDate preceeds Sal would it cause issues ?

EmpId Empname Dept StartDate Sal EndDate EmpType

As i'm getting the following errors when trying to run this package:

[Excel Source [37]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager 2" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.

[SSIS.Pipeline] Error: Excel Source failed validation and returned error code 0xC020801C.

[SSIS.Pipeline] Error: One or more component failed validation.

Error: There were errors during task validation.