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

Jul
15
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.
Jul
15
answered Database/Storage engine suggestion for a project involving heavy inserts?
Feb
4
awarded  Supporter
Nov
16
awarded  Yearling
May
1
answered Visualiser for spatial query results
Apr
4
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.
Apr
4
answered Modify legacy table schemas that have no primary key
Apr
4
answered SSIS Design consideration with object variables
Apr
2
awarded  Editor
Apr
2
comment Convert rows to columns in SSIS. Unpivot?
Elaborated my answer - see above.
Apr
2
revised Convert rows to columns in SSIS. Unpivot?
clarifications
Mar
28
answered Import batches of rows from Excel in parallel
Mar
28
answered Convert rows to columns in SSIS. Unpivot?
Mar
28
answered SSIS Package Data Flow Task RollBack on Error
Nov
16
awarded  Revival
Nov
16
awarded  Teacher
Nov
16
answered Dynamic Dimension Security