Lynn and ChrisM, many thanks for your suggestions. I have incorporated them into my code and much happier now as I'm not a massive fan of row-by-row processing, although it...

OK, I left things running over the weekend and checked just now. The job runs every day at 3am. and it is the same job with the same code that runs.

Sorry, I meant to say " record 8 onwards is missing" when talking out the text file content.

Thank you for all the replies on this post. All taken on board and will be acted upon.

Thanks again.

Max server memory is set in SQL Server to 16GB.

Available MBytes over the same period was:

Hi Gail,

I have solved it, but you did spark me to look deeper at all the deny permissions, so thank you for that.

One of my network...

Hi Sue_H,

I've decided to go down a different route and use ASP.NET instead, but thank you for responding.

Regards,

Mark

Sorry, I should have posted this from the SSRS log file too:

library!ReportServer_0-2!267c!07/03/2017-16:03:47:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.StreamNotFoundException: , Microsoft.ReportingServices.Diagnostics.Utilities.StreamNotFoundException: The stream cannot be found. The stream identifier that...

Thank you for your reply Luis.

I dismissed the global temp table because this is something that multiple users will be doing concurrently, so for now I am going down the...

Sorry, that second bit of MDX should read:

Iif(Ancestor([Customer].CurrentMember, [Customer].[Account No]).Name = [Customer].Currentmember.Name, RollupChildren([Measures].[On Time], "+")/[Measures].[Distinct SOs], Null)

Please ignore the [Measures].[On Time #0] in the original one I posted, it should...