Use row_number function to get the ranks and add the current value to previous value

Yes I have used the media wiki not only for documenting only SSIS, but complete SQL Server Environment. However its a tedious process.

The best way to do it would be via a SQL Script. Though it would be tedious task. I dont see how you can use SSIS to do...

Well, if the data in the datawarehouse is correct there is nothing problematic in ETL. I work for ETL and we just port the OLTP data into OLAP data...