I have excel files (reports type data in excel sheets), I need these data to be import into SQL table. at the moment I spend most time to massage the data to reformat to extract into SSIS tranformation. This is time consuming task, is there are any machanism on SSIS component or can SSIS be extend it's capabilities by directly reading excel cell or range of excell cells and load the data into SQL table. I am thinking about solution VB scripts or C# script which can read data from the cell level of the excel worksheet. The standard way of reading data from excel source with excel's sheet level. I need to go another level down to read the range of cells and load those data into particular tables using SSIS.
Appreciate any help on this.
Thanks in Advance