I've coded around it for now, with an Expression;
@[User::SourceFilePath] = LEFT( @[User::SourceFilePath], LEN( @[User::SourceFilePath] ) - FINDSTRING(REVERSE( @[User::SourceFilePath] ), "\\", 1 )) + "\\Pending"...

Does your VIEW (XF_GISFPF_History_Security_vw and XF_GISFPF_History_Instrument_vw) need to use UNION rather than UNION ALL.

What is 1=1 trying to achieve here?

It looks like you're selecting data from views as well; we'll need the DDL of those as well ideally to help on...

I suspect that you have a trigger that assumes that only one row will ever be inserted at a time. Post the DDL, like Eirikur asked for, and we'll very...

You'll need to use an IIf:

=IIf(Sum(Fields!servicetotal.Value, "Service") - Sum(Fields!servicefee.Value, "Service") < 0, 0, Sum(Fields!servicetotal.Value, "Service") - Sum(Fields!servicefee.Value, "Service"))

Not really sure what you're after here. What are you trying to actually achieve? What is your Execute T-SQL task meant to do, execute all/a procedure listed in the table?

This is a duplicate of this topic, https://www.sqlservercentral.com/Forums/2014453/Expanding-Columns-in-SSRS-Report you posted last month. I responded to your post there and explained the basics. Rather than posting a new topic perhaps...

No. The licences are both edition and version specific. A licence for 2016 enterprise cannot be used for any other editions of SQL Server 2016 (such as standard) or other...