Hi,
I have a range of excel files that I need to load into the database. Each file can have a varying number of columns and varying column names. I hold the mapping between the file column names and db column names in a sql table. I want to extract specific columns in each file and then save them to a common sql table. SSIS lets you extract data from a excel file and stick it into a recordset. Problem I have is the columns and number of columns is dynamic so I can not specify to a record set what columns to expect. Is there a way round this?
Thanks!