I disagree with most of this article suggests:

1) Entire tablenames as alias make the code harder to read and understand. There's nothing wrong with aliasing an...

This article is nothing more than a re-hashing of old nostalgic experiences and personal grudges.  Where is the analysis, where is the insight?  What can we walk away with except that...

The other DBA who "claimed" to have 10 years experience may know a little more about DTS then you do.  First off if you don't create separate connections for each...