troubleshooting Question
Can SSIS package extend it's capabilities to extracts data from cells in a excel file rether than sheets level?
asked on
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
Appreciate any help on this.
Thanks in Advance
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.