network profile
| bio | website | mangasolutions.com |
|---|---|---|
| location | Melbourne, Australia | |
| age | ||
| visits | member for | 7 months |
| seen | May 1 at 23:25 | |
| stats | profile views | 6 |
|
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 |
