Interesting.  Every time I see something like this, the more happy I am that I don't use SSIS ;-).  A BCP FORMAT FILE and the use of BULK INSERT would...

Thanks for the feedback.  I also meant to say that, contrary to what many people think/claim, partitioning usually results in somewhat slower query performance than when a good query plays...

Or possibly using RANK.