Hi

I have blogged about ranking over partitions in SSIS here (using a code transform)

http://paultebraak.wordpress.com/2013/02/25/rank-partitioning-in-etl-using-ssis/

Regards,

Paul