you need to select it - from your image while it is available, it is not selected hence it won't log

by using SSIS you need to also worry about the SSIS execution timeout itself on top of the remote server one

and you also have to worry about the serverwide remote...

use a "group by" on the string_agg sub query

I would change the following

(1 + (COALESCE(Factor,0)/100)) * @PreviousCalculation

to be

(1 + (COALESCE(Factor,0.)/100.)) * @PreviousCalculation -- notice the "dot" on the divide (100.) and on coalesce of factor-

depending on the values...

PowerQuery source works in SSIS - just needs to be done correctly (which you on your thread about it seem to have done all required EXCEPT 1 very important step...

within SSMS

Database ->Storage->Partition Functions

Database ->Storage->Partition Schemes

yes you can copy them to another location and process them on a different server.

you read them in SQL Server as any other .xel file (or through powershell - google it)

folders like this should be owned by a group containing the domain administrators - and then these can grant required permissions to  local administrators and other accounts as needed

starting to get annoyed with this user https://www.sqlservercentral.com/forums/user/srinivasdba19

been posting scripts (and not his own for sure) as reply to a whole bunch of threads - some of the scripts are...

doesn't the hotfix work?

'{000C1B7A-164A-4243-9952-01BC82236EB0}' is not the same as '000C1B7A-164A-4243-9952-01BC82236EB0'

some changes on forums are acceptable - SQL ServerCentral change from old format was a "soft" change and not a "I will never use this again" change.

I used to be...

issue with using a "specific login" is that a sysadmin can execute as any login - so it will still not prevent a DBA from doing it which was the...

you can't - and if you don't trust your dba's not to use it then change the process of accessing that linked server so that it is on a black...