246 reputation
bio website mangasolutions.com
location Melbourne, Australia
visits member for 1 year, 8 months
seen Jul 16 at 6:52

comment Database/Storage engine suggestion for a project involving heavy inserts?
The best resources (books, articles, training) on Data Warehousing IMO are from the Kimball Group.
comment SSIS Design consideration with object variables
From my experience the minimal effort to set up SQL tables pays off even during your Unit Testing phase. You can easily write and reuse test SQL queries to check and compare your results at each iteration and for varying inputs. SQL has no problem handling multiple inputs and parallel executions - just dont lock the target tables. In that scenario I would be more worried about running out of RAM with your current design. SSRS is optional - once you have the data in tables you can use a wide range of tools to get it out.
comment Convert rows to columns in SSIS. Unpivot?
Elaborated my answer - see above.