Sorry, I used the wrong word. It was the package file I checked. Apologises for the error in my post.

Thanks for your help.

I didn't know about the possibility of reading the project file in Notepad++ .  I've now checked it and I can't find gmlFileA in loopB.

I'll keep looking...

Thanks for your help.

For now I have it setup as in the attached (it doesn't look like I can paste an image into a reply?).

All of the loops are 'for...

People tend to be nervous of opening attached files. Can you post it into a code block as you did in your first post?

I think you are asking about SQL data backups only rather than backups of the server configuration (by that I mean the operating system, cluster configuration e.t.c). In which case...

Thank you for your help.

In relation to my previous post here is the final expression:

"e \"C:\\Users\\username\\Downloads\\stackoverflow\\032020 StackOverflow\\" + (DT_WSTR,255)( @[User::FileName]) + "\""

Thanks for the advice. You are correct I had to make further corrections. When I have access to the system again I'll post the final expression in case it helps...

Both: Thanks for your help.

Thom A: Sorry I didn't think of pasting as text. I will do in future.

I've just compared AlphaTangoWhiskey's  example against mine and found the issue. It...

• This reply was modified 5 years, 5 months ago by as_1234.

I think I partially figured this out? My understanding is as follows?:

Some functions in DAX use 'row context' and some use 'filter context'.

A function using 'row context' can't join tables...

I am only a beginner on SSRS so can only suggest some things you may have already tried:

Are there any other admins? Do they have the same problem?

Do you get...

Hello,

We'll need a bit more information to help you. Can you provide the information described here https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help ?

If you are not sure about the details in the link then...

This is a guess based on exporting to Excel from other systems. SSIS may be maintaining a file lock on the template file so when you try and run the...

If I understand your setup correctly then there should be something in the following locations:

Windows Cluster event logs

SQL Server logs

This is a really useful article. Thank you.