"I opened a DTS package; it transferred five tables from one database of one server to another database of another server. Well, how many connections would you create? Two right? I saw TEN connections - two for each table. The most amazing thing was the DTS package was written by a DBA who claimed to have over 10 years' experiences. "

Actually, with only two connections, the table population would have to go one at a time (table1, then table2, then table3, ...). With one set of connections (source and destination) for each table, they can run in parallel (If memory serves, the default is 4 parallel processes at a time. This would mean a faster executing package.

Maybe you should have asked the DBAs for the reason behind their design...