Microsoft has published a performance benchmark on loading 1TB of data using ETL stuff in SSIS 2008. They say the are the first ever to do this, read more about it here. Our well-known colleague Jamie has some thoughts about it too. Details about the benchmark have been given by Len Wyatt. A whitepaper will soon follow.
I hope this new record drives others to compete this performance, cause in the end that will certainly be good for the performance of SSIS 2008 too !