Still got this problem?

Try checking the dimension attribute security settings for the role. there may be explicit allow/deny for a attribute or Dim where the name has changed.

Both very Valid points. I hadn't even considered checkpoints; mostly because I have never been posed with this problem until now and I have never used the OLE DB...

Guys,

Thanks for the replies. yes I had considered the EXEC SQL task. I wanted to update the table as each row passes through. So if there is...

No issues here for me. I have a 64bit SQL with a 32bit IIS machine serving reports quite happily.

Installation was dead easy too and licensing states that...