SSIS: working with Excel source data
Posted on 2010-08-17
I have a large Excel spreadsheet that I want to load into an SSIS package and output relational datasets.
My first throught was to load the data straight into a recordset and then through code and loops, pull out the data into new recordsets.
Next, I've been playing with the Excel source editor and trying to query the Excel data and then intending to just output the query results into recordsets (but I'm receiving the error: No column information was returned by the SQL command).
Which method would be better to work with and how should I go about doing it?