Working with unstructured, but consistent Excel data
Hello, I'm trying to automate a data load procedure via SSIS. The catch is that I'm dealing with an unstructured, but consistent, Excel data file. The file is always structured the same, just not in a nice uniform column/row structure. See the following screen capture: As you can see, the column headings I need are in green, and the values are in red. As I said, this is a consistent format in that the first row of data is always A9, and the parameter headings always start at E6. Can SSIS handle something like this? Any suggestions, or info would be greatly appreciated. Thanks! Warren MWarren M
June 19th, 2012 3:21pm

Hi Warren you simply must skip the 1st 8 rows using a SQL query against Excel. This technique is best described here: http://sqlserversolutions.blogspot.ca/2009/02/selecting-excel-range-in-ssis.htmlArthur My Blog
Free Windows Admin Tool Kit Click here and download it now
June 19th, 2012 3:24pm

Hi Warren you simply must skip the 1st 8 rows using a SQL query against Excel. This technique is best described here: http://sqlserversolutions.blogspot.ca/2009/02/selecting-excel-range-in-ssis.htmlArthur My Blog
June 19th, 2012 3:28pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics