I agree that the naming convention should certainly be used to clearly identify sources and destinations as well as transform steps. As for using descriptive text at the top of your DTS packages, perhaps consider hiring a DBA capable of making a couple of clicks to find out info instead. It'll keep your packages cleaner and many of the objects in DTS are self-describing anyway. With a good naming convention, you should be all set.

By the way, the Green Lantern rocks!