Hi @Greg Booth ,
- If you need to copy table by table, i.e. no need for any relationship, it is better to have one single source and destination in a Data Flow Task (DTF).
- It is better to use SSIS Sequence Containers for parallelism by placing multiple DFTs in them. After that DFTs will be executed in parallell manner.
- Degree of parallelism is not unlimited. it is dependent on the number of logical processors on the SSIS run-time server.