Hi Sam,

I need more details to make a suggestion:

- Do all the dimensions conform? That is, the dimensions are common to all of the fact tables.

- You said that there are 2 star schemas but 4 fact tables. Then it should be 4 star schemas, one per each fact table, or may be some fact tables are the same but with different aggregation levels?

- Which version of the SSIS are you using?

Kind Regards.