I would agree and would like to use the Multicast. I attached a image of what my Data Flow looks like at the moment.

How can I upload my excel data to a temp table from with SSIS? Or do I even have to do that?

Regards,

D