I have identical source databases(SQL Server) that I want to perform parallel ETL into single DW. The number of source databases can vary, so some sort of dynamic connection configuration will be required. However, executing packages in a loop for each connection will not provide parallel behavior.
Will appreciate if someone can provide some design pattern to achieve this. Being a new system, it has full flexibility to incorporate this.