Excel Column Order
HiI am planning to build a map that uses an Excel spreadsheet as the source from a watched folder and upload the data to a SQL table.� I will reference the Excel columns as Source Columns under Column Type in the mapping window.� My question is this – does the order of the columns in the spreadsheet matter since I am referencing them by name? In other words, if I have two spreadsheets that have the same column names and number of columns but the order of the columns between the two differ, will it still upload both or will it upload one and throw an error on the other one?