Ahh... we are getting there.

You did say that after running a dimension process folowed by a full process in Analysis services, you then reran the SSIS task successfully?

And from the new warning/error messages posted; you are missing attribute keys. Thats probably because your fact table contains dimension keys that do not exist in the dimension at the time you process the measures.

Or are you processing the dimension & cube in the same task? Do not do this.

Add a Process Analysis task to process the 'Provision' dimension BEFORE the task that processes the ''fact_SEN_Fact'' measures. Do this in different Processing tasks using a 'Success' constraint from the dimension process to the measures process.

Also ensure that your fact tables are not being modified once you've started the dimension processing. If you have 'early arriving facts' then this problem will continue. you can check if you have 'early arriving facts by performing a lookup between your 'Provision' dimension table and ''fact_SEN_Fact'' table.

That'll come at a later stage. Try seperating your processing tasks and creating a process dimension before process measure task.

Let me know how you get on. 🙂