You need to define and reuse the connection managers in all the packages by using the least development effort
You need to design the implementation strategy to meet the requirements while minimizing development and deployment effort and maximizing data flow performance