This just gets worse....

I changed everything to full process and ran and 1 dimension and both cubes failed again (Like an idiot I didnt check the reasons for the fail)

I processed it in Analysis Services and it ran successfully.

I am really beginning to dislike Integration Services. Its very hit and miss. :blink: