I am using SSIS to convert data from excel to OLEDB SQL. I have a set of sheets in a folder in which I have to loop and insert data into each of these sheets in a table. I have a scenario where I have to go in cycles on a set of Excel worksheets that have different column structures. I can loop through each sheet through the foreach loop enumerator to find the file name and pass it to the Excel source.
I want to know if there is a way to avoid these column mappings in the target component, which in my case would be an OLEDB SQL table. Because these mappings are different for each file. Is there a way to do this dynamically?
source
share