I want periodically to insert data from an excel file into a relational table using a SSIS package. However, each time the number of columns in excel may vary. For example, the 1st time the excel file may have 100 rows the second 105 rows etc.
Can this be done in SSIS and if yes what is the solution?
Thanks in advance,
View Complete Post