I agree.
The Microsoft Datawawrehouse Toolkit, chapter 7, has great tips for loading fact tables along with sample scripts and SSIS packages to go with it. The 2005 version gives you more of a step-by-step tutorial; whereas, the newest version, SQL Server 2008 R2 Edition, maps the the SSIS product to the 34 subsystems of ETL along with giving you advice on establishing standards.
My biggest tip: Once you have mastered the art of the lookup transform, remove all foreign keys in your fact table. Like the author states, they are "technically right, but practically wrong" as FKs add unnecessary overhead for a check you just performed in the lookup transform.
Book and code samples can be found here:
The 34 subsystems of ETL can be found in the Kimball Group Reader or on their website: http://www.kimballgroup.com/2007/10/21/subsystems-of-etl-revisited/