2 ms·
Sure. Two of the main ones I used were MSSQL Analysis Services and Integration Services. I built and managed a data warehouse/internal reporting system for a f
by matwood 8y ago
Sure. Two of the main ones I used were MSSQL Analysis Services and Integration Services.
I built and managed a data warehouse/internal reporting system for a fairly large telecom. I used ~100 ETL packages built in SSIS to pull in data from systems all over the company, SSAS to process the data and SSRS to build reports. It worked pretty well at the time 10+ years ago.