The SSIS Onion

A customer requested to upgrade their ETL pipeline system (which I helped develop back in 2001 using SQL 2000’s DTS) This pipeline system was nothing more than a bunch of DTS that could be fired with certain parameters to work on certain data. So we ended up building a VB6 simple program that could load,… Read More »

Cube Builder

Cube Builder is a .NET Client/Server application divided in three different modules which aim to perform the following: – Register Several OLAP Clients in a farm, split by a dividing criteria (user created Groups, also called Affinity Groups) – Clone OLAP cubes using the SSAS Services by Microsoft – Distribute evenly the work among the… Read More »