network profile
| bio | website | mangasolutions.com |
|---|---|---|
| location | Melbourne, Australia | |
| age | ||
| visits | member for | 6 months |
| seen | May 1 at 23:25 | |
| stats | profile views | 6 |
|
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 2 |
comment |
Convert rows to columns in SSIS. Unpivot? Elaborated my answer - see above. |
