SSIS Multiple Data Destinations

You can also have multiple Data Flow tasks. So there can be multiple Data Flow tasks running in parallel (threads) or in sequence. You can then take the data from one destination table and use it as the source for another Data Flow.

In SSIS Data Flow task data flows through "pipes" or "streams". Each pipe can get to one destination only. To split a pipe into several pipes use Multicast from the Toolbox, when you are on Data Flow tab. Then link several pipes to their destinations.