Thank you so much for the reply. I had an idea that fact tables should be loaded last, I didn't know how to proceed with the dimension tables in snowflake schemas. Indeed, parallel execution in ssis has to follow the same logic.

Ionut