business people sent me an excel file.
looks like the picture. this is not very well data friendly. there is no column name.
They want to import data from this excel sheet to sql server using ssis.
in SQL server, a table will be created with two columns, Code and Name.
it will be like this in sql server.
101010 Energy Equipment & Services
101020 Oil,Gas & Consumable Fuels
10101010 Oils & gas Drilling
10101020 Oil & Gas Equipments & services
I do not keep the description.
Basically, we want to keep the numeric code and name only. Numeric codes are in column a,c,e,g. names are in column b,d,f,h
is this possible?